Install phpMyAdmin on a 1&1 Cloud Server with Linux

Table of Contents

Introduction

PhpMyAdmin is a convenient way to manage MySQL/MariaDB for those who prefer a browser-based interface over the traditional command-line interface. Learn how to install and use phpMyAdmin on a 1&1 Cloud Server with Linux (Ubuntu 16.04 or CentOS 7).

Requirements

  • A 1&1 Cloud Server with Linux.
  • MySQL/MariaDB installed and running.
  • PHP installed and running.

Note: PHP and MySQL/MariaDB are installed and running on a Standard Linux installation by default. If your server was created with a Minimal installation, you will need to install and configure PHP and MySQL/MariaDB before you proceed.

Ubuntu 16.04

To install phpMyAdmin on Ubuntu 16.04, update the packages on the server:

sudo apt-get update

Then install phpMyAdmin with the command:

sudo apt-get install phpmyadmin 

Hit the space bar to select the Apache option, then press the Tab key and Enter to proceed.

Follow the prompts to complete the installation. Choose Yes to enable dbconfig-common then enter the root MySQL/MariaDB password.

You can now access phpMyAdmin at http://example.com/phpmyadmin.

CentOS 7

To install phpMyAdmin on CentOS 7, first install the EPEL repository:

sudo yum install epel-release

Then install phpMyAdmin with the command:

sudo yum install phpmyadmin

Next, you will need to edit the configuration file to allow access from your desktop computer. To find your IP address, you can simply search Google for "What's my IP address."

Open the configuration file for editing:

sudo nano /etc/httpd/conf.d/phpMyAdmin.conf

Change the lines which read:

Require ip 127.0.0.1 
Allow from 127.0.0.1

These lines are repeated, so you will need to change four lines in total.

Change the IP address 127.0.0.1 to your IP address:

Require ip 192.168.0.1
Allow from 192.168.0.1

Then save and exit the file.

Restart Apache for the changes to take effect:

systemctl restart httpd

You can now access phpMyAdmin at http://example.com/phpmyadmin.

Secure PHPMyAdmin

We recommend you password-protect your phpMyAdmin installation, to help prevent malicious users from accessing it from the web.

For step-by-step instructions on how to set this up, see our article Password Protect a Directory with Apache.

Comments

Tags: MySQL/MariaDB