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:
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:
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:
You’d need to start MariaDB on boot. So use this command for that purpose:
By default, MariaDB is not secure. You’d have run the following command to secure it:
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:
When prompted, press Y and enter to confirm the installation process. Once finished, you need to restart Apache using the following command:
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.
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 updateEnsure 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
Code:
$ sudo yum install mariadb-server mariadb
$ sudo systemctl start mariadb
Code:
$ sudo systemctl enable mariadb
Code:
$ mysql_secure_installationInstall 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
Code:
$ sudo systemctl restart httpdFinally, 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.
