"Mysql" phpMyAdmin Installation and configuration

phpMyAdmin concept

PhpMyAdmin is a PHP-based, web-base-style MySQL database management tool that is architected on a Web site host, allowing administrators to manage the MySQL database using a Web interface. This web interface can be an easy way to enter complex SQL syntax, especially to handle the import and export of large amounts of data. One of the bigger advantages is that because phpMyAdmin is executed on the Web server like any other PHP program, you can use the HTML pages generated by these programs anywhere, that is, to manage the MySQL database remotely, to easily create, modify, and delete databases and data tables.

Installation Environment

Operating system: Linux (CentOS 6..5 version)

Integrated environment: LMAP Environment

Installation steps

• Download phpMyAdmin, official website: http://www.phpmyadmin.net/
• Unzip the file, phpmyadmin-4.0.10.16-all-languages.tar.gz to the Apache project directory (/var/www/html)

　　　　

• Go to phpMyAdmin, copy the phpMyAdmin simple profile as the default configuration file

　　　　

• Configure the host for the phpMyAdmin. Change to the host you want to connect to

　　　　

If there is an error #2002 cannot log on to the MySQL server, you need to modify this

• Use: IP: Port/phpmyadmin on the browser for access

　　　　　

　　　　　　

"Mysql" phpMyAdmin Installation and configuration