Ph­p­MyAd­min is a con­ve­nient way to manage MySQL/MariaDB for those who prefer a browser-based interface over the tra­di­tion­al command-line interface. Learn how to install and use ph­p­MyAd­min on a Cloud Server with Linux (CentOS 7).

Re­quire­ments

  • A Cloud Server with Linux.
  • MySQL/MariaDB installed and running.
  • PHP installed and running.
Free Cloud Server Trial
En­ter­prise-grade virtual private servers
  • KVM based dev servers for de­vel­op­ers
  • Scalable to en­ter­prise cloud level
  • Pay-as-you-go, per-minute billing
Note

PHP and MySQL/MariaDB are installed and running on a Standard Linux in­stal­la­tion by default. If your server was created with a Minimal in­stal­la­tion, you will need to install and configure PHP and MySQL/MariaDB before you proceed.

To install ph­p­MyAd­min on CentOS 7, first install the EPEL repos­i­to­ry:

sudo yum install epel-release

Then install ph­p­MyAd­min with the command:

sudo yum install phpmyadmin

Next, you will need to edit the con­fig­u­ra­tion 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 con­fig­u­ra­tion 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 ph­p­MyAd­min at "https://www.example.com/ph­p­myad­min".

Go to Main Menu