Simply put, phpMyAdmin is a MySQL management tool, after installing the tool, you can directly manage the MySQL data through the web, without the need to execute system commands to manage, is very suitable for database Operations Command unfamiliar Database manager, Here's how to install the tool:
1. First go to the Internet to download phpMyAdmin, and then extract to the Web directory can be accessed (if it is virtual space, can be extracted via FTP and other uploads to the web directory), of course, you can modify the name of the file after decompression.
2. Configure config file
Open the config.default.php file under libraries, locate the following, and then follow the instructions to configure it:
A. Access to the Web site
B.mysql Host Information
C.mysql User name and password
$cfg [' Servers '] [$i] [' user '] = ' root ';//MySQL User access the MySQL user name used by phpMyAdmin
fg[' Servers ' [$i] [' password '] = '; MySQL password (only needed password corresponding to the above MySQL username
D. Authentication methods
$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 cookie2881064151
E. Setting of the phrase password (blowfish_secret)
$cfg [' blowfish_secret '] = ';
If the authentication method is set to a cookie, you will need to set the phrase password, put in the setting why the password, it is up to you to decide, but can not be left blank, or you may be prompted with error when logging in phpMyAdmin
OK, so far, you have successfully installed the phpMyAdmin, simple, quickly login experience it
$cfg [' pmaabsoluteuri '] = '; Fill in phpMyAdmin's access URL here
$cfg [' Servers '] [$i] [' host '] = ' localhost ';//MySQL hostname or IP address
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-leave blank for default port
MySQL port, if it is the default 3306, leave it blank
Setting of the phrase password (blowfish_secret)