Build a graphical interface in the LAMP environment to configure the MySQL database

By default, the RPM package or source code package of MySQL does not provide a graphical management tool. phpMyAdmin is the most famous among these tools. PhpMyAdmin (Official Website:

By default, the RPM package or source code package of MySQL does not provide a graphical management tool. phpMyAdmin is the most famous among these tools. PhpMyAdmin (Official Website:

By default, the RPM package or source code package of MySQL does not provide a graphical management tool. phpMyAdmin is the most famous among these tools.

PhpMyAdmin (Official Website) is a PHP-based MySQL database management tool. PhpMyAdmin allows administrators to manage MySQL databases through the Web. PhpMyAdmin is executed on the Web server like other PHP programs. However, you can use the HTML pages generated by these programs anywhere to remotely manage MySQL Databases and easily create, modify, and delete databases and tables.

Note the phpMyAdmin version requirements for PHP and MySQL:

1. Download phpMyAdmin and decompress it.

Download to the/data/software/directory

2. Move the extracted directory to the directory of the Apache website.

Copy the phpMyAdmin configuration file template.

Modify the SELinux status.

3. Start httpd and mysqld services

Since I have configured the LAMP environment, Apache and MySQL services have been successfully run.

4. Access phpMyAdmin

After the preceding configuration is complete, you can access phpMyAdmin. For example:

PhpMyAdmin can automatically adjust the displayed language based on the operating system language used by the client.

One mcrypt extension is missing, which is an encryption method. It can be installed later. We recommend that you install it. It is used to encrypt the data transmitted between the Web client and the server to ensure the security of PHP and database.

Note: by default, phpMyAdmin considers that it is on the same host as the managed MySQL. If it is not on the same host, you can modify "/var/www/html/phpmyadmin/config. inc. php file with the following content:

$ Incluservers [1] ['host'] = 'localhost ';