A Complete Guide to Installing phpMyAdmin on CentOS (VPS and Dedicated Server)

A Complete Guide to Installing phpMyAdmin on CentOS (VPS and Dedicated Server)

phpMyAdmin is a great way to manage MySQL or MariaDB from within a browser. The intuitive GUI that it has allows you to create, delete, and maintain databases with ease. You can even run queries without the need to open a terminal. In this guide, learn how to install phpMyAdmin on a CentOS platform that is hosted on a VPS or Dedicated server.

Step-by-Step Process

Here are the steps you need to follow:

Update your System

The first step to take is have an updated system. phpMyAdmin will work best with recent optimized versions of software and dependencies. Therefore, run the following command to update your system:

Code:
$ sudo yum update
When prompted, press Y and then Enter to start installing updated versions.

Ensure that MySQL/MariaDB is Working Fine

The next step is to check if your databases are working just fine. To check, run one of the two commands from below:

Code:
$ systemctl status mariadb
$ systemctl status mysql
You should get an ‘Active’ status with green color if MySQL or MariaDB is working. In case you don’t have MariaDB on your server, here’s the command to install and then start it:

Code:
$ sudo yum install mariadb-server mariadb
$ sudo systemctl start mariadb
You’d need to start MariaDB on boot. So use this command for that purpose:

Code:
$ sudo systemctl enable mariadb
By default, MariaDB is not secure. You’d have run the following command to secure it:

Code:
$ mysql_secure_installation
It’d further guide you in setting password and removing anonymous users from the list. Once completed, move onto the next step.

Install phpMyAdmin

Now that you’ve set everything up, it’s time to install phpMyAdmin. To get started run the following command:

Code:
$ sudo yum install phpMyAdmin
When prompted, press Y and enter to confirm the installation process. Once finished, you need to restart Apache using the following command:

Code:
$ sudo systemctl restart httpd
Run some Tests

Finally, you’d have to run some tests to check the installation. Visit this address from your web browser ‘http://ip_adress/phpmyadmin’. If the installation was as intended, then you’d see a login screen for phpMyAdmin. This confirms that the installation was successful.

So that’s how you install phpMyAdmin on your CentOS server. For more assistance, get in touch with the hosting support team.
Author
kumkumsharma
Views
209
First release
Last update
Rating
0.00 star(s) 0 ratings

More resources from kumkumsharma

Top