[Introduction] phpMyAdmin is a MySQL database management tool, after the installation of the tool, you can directly manage the MySQL data through the web, without the need to execute system commands to manage, very suitable for database Operations Command unfamiliar Database manager, the following details
PhpMyAdmin is a MySQL database management tool, after the installation of 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, the following details the installation method of the tool.
Download Address: |
PHPMyadmin |
First, download
First multi-special software station download PhpMyAdmin, can also go to phpMyAdmin official website to download, and then extract to the Web can access the directory, if it is virtual space, can be extracted through the FTP tool upload to the Web directory, and you can modify the name of the file after decompression.
Second, the configuration
Open the config.default.php file in the Libraries directory, locate the following, and then follow the instructions to configure it.
1. Visit the website
$cfg [' pmaabsoluteuri '] = '; Fill in PhpMyAdmin's access URL here.
2. MySQL Host Information
$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, the default is 3306, left blank, if you install MySQL using a different port, you need to fill in here.
3. MySQL User name and password
$cfg [' Servers '] [$i] [' user '] = ' root '; Fill in the MySQL username used by MySQL access phpMyAdmin, which defaults to root.
fg[' Servers ' [$i] [' password '] = '; Fill in the password corresponding to the MySQL user name above.
4. Authentication method
$cfg [' Servers '] [$i] [' auth_type '] = ' cookie '; For security reasons, it is recommended that cookies be filled in here.
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 key 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.
5. Setting the phrase password (blowfish_secret)
$cfg [' blowfish_secret '] = '; If the authentication method is set to a cookie, you need to set the phrase password, set why the password, by your own discretion, here can not be left blank, otherwise you will be prompted when login PhpMyAdmin error.
After the installation is complete, we can access it in the browser, as shown in: