Installation and use of phpMyAdmin

First download the corresponding phpMyAdmin version in the phpMyAdmin's official website based on your PHP and MySQL version.

The Red box section of the figure identifies the PHP version and the MYADL version of this version of the support amount.

For example, this version is supported for PHP5.3 and MYSQL5.5 versions. Get PHP and MySQL version see http://www.cnblogs.com/yiluxiuxing/p/4307296.html (Get PHP configuration information)

Download the phpMyAdmin folder and upload it directly to the Web site root directory.

Open the phpmyadmin/libraries/config.default.php file for editing.

Find the following variables and edit

$cfg [' pmaabsoluteuri '] = ' http://www.simple.com/phpmyadmin ';//fill in phpMyAdmin's access URL here

$cfg [' Servers '] [$i] [' host '] = ' localhost '; Fill in the IP address of localhost or MySQL server, and if MySQL and the phpMyAdmin are on the same server, press the default localhost

$cfg [' Servers '] [$i] [' port '] = '; MySQL port, if it is the default 3306, leave it blank

$cfg [' Servers '] [$i] [' user '] = ' root '; MySQL user access phpmyadmin using the MySQL username

fg[' Servers ' [$i] [' password '] = '; MySQL password (only needed password corresponding to the above MySQL username

$cfg [' Servers '] [$i] [' auth_type '] = ' cookie ';

There are four different modes to choose from, Cookie,http,http,config

The Config method is to enter the phpMyAdmin access URL directly, no need to enter the user name and password, is not safe, is not recommended to use.
When the entry is set to Cookie,http or HTTP, the login phpMyAdmin requires a data user name and password for authentication, as follows:
PHP installation mode is Apache, you can use HTTP and cookies;
PHP installation mode is CGI, you can use cookies

After the configuration is complete, if the browser enters http://www.simple.com/phpmyadmin to log in

If the display fails to log on to the server

Will $cfg[' Servers ' [$i] [' host '] = ' localhost ';

Instead of $cfg[' Servers ' [$i] [' host '] = ' 127.0.0.1 ';

Installation and use of phpMyAdmin