How to install phpMyAdmin on CentOS with LNMP
How to Install phpMyAdmin on CentOS
phpMyAdmin is a free and open source web-based tool for managing MySQL and MariaDB databases. It provides an easy-to-use interface that enables users to perform various tasks such as creating, modifying, and deleting databases, tables, and fields. This article will guide you through the process of installing phpMyAdmin on CentOS.
Before proceeding with the installation process, you must have the following prerequisites:
- A CentOS server with root access
- Apache web server installed and running
- PHP installed and running
- MySQL or MariaDB installed and running
To install phpMyAdmin on CentOS, follow the steps below:
- Open a terminal window and log in as root.
Run the following command to install the EPEL repository:
yum install epel-release
Once the repository is installed, run the following command to install phpMyAdmin:
yum install phpMyAdmin
After the installation process is complete, open the phpMyAdmin configuration file using your preferred text editor:
Uncomment the following line by removing the ‘#’ symbol at the beginning of the line:
# Require ip 127.0.0.1
Save and close the file.
Restart the Apache web server:
systemctl restart httpd
Open a web browser and navigate to your server’s IP address followed by ‘/phpMyAdmin’. For example, if your server’s IP address is 192.168.1.100, navigate to:
You will be prompted to enter your MySQL/MariaDB username and password. Once you have entered them, click on the ‘Go’ button.
In conclusion, phpMyAdmin is a powerful tool for managing MySQL and MariaDB databases. By following the steps outlined in this article, you should now be able to install phpMyAdmin on CentOS and start using it to manage your databases. If you encounter any issues during the installation process, refer to the official phpMyAdmin documentation for further guidance.
Small world. Big idea!
- Welcome to visit the knowledge base of SRE and DevOps!
- License under CC BY-NC 4.0
- No personal information is collected
- Made with Material for MkDocs and generative AI tools
- Copyright issue feedback me#imzye.com, replace # with @
- Get latest SRE news and discuss on Discord Channel