Description
phpMyAdmin is a MySQL database management tool, after the installation of the tool, that is, the Web form can directly manage the MySQL data, without the need to execute system commands to manage, is very suitable for database operation commands unfamiliar database managers, the following detailed description of the tool installation method.
Realize:
A. Download phpMyAdmin
The code is as follows |
Copy Code |
# cd/usr/local/src/ # wget Http://superb-dca3.dl.sourceforge.net/project/phpmyadmin/phpMyAdmin/4.0.5/phpMyAdmin-4.0.5-all-languages.zip # Unzip Phpmyadmin-4.0.5-all-languages.zip # MV Phpmyadmin-4.0.5-all-languages/home/www/gaingreat/phpmyadmin//Move phpMyAdmin to the site root directory |
Two. Configuration, config.default.php files under the libraries directory
code is as follows |
copy code |
Vim libraries/config.default.php //modify content as follows $cfg [' pmaabsoluteuri '] = '; //fill phpmyadmin access URL As I'm going through HTTP ://www.111cn.net/phpmyadmin, fill in the Http://www.111cn.net/phpmyadmin ... $cfg [' Servers '] [$i] [' host '] = ' localhost ';//fill in the IP address of the server where localhost or MySQL resides, if MySQL and phpMyAdmin are on the same server, Then press the default localhost ... $cfg [' Servers '] [$i] [' port '] = '; //mysql port, the default is 3306, leave blank, if you have installed MySQL with other ports, you need to fill in here. ..... $cfg [' Servers '] [$i] [' user '] = ' root '; //fill in the MySQL username used by MySQL access phpMyAdmin, default to root $cfg [' Servers '] [$i] [' password '] = '; //fill in the password corresponding to the MySQL user name above ... $cfg [' Servers '] [$i] [' auth_type '] = ' cookie '; //authentication method. For safety reasons, it is recommended to fill in cookies here. There are four different modes to choose from, Cookie,http,http,config |
Config mode is to enter the phpMyAdmin access URL can be directly entered, without entering a username and password, is not safe, do not recommend use.
When the entry is set to Cookie,http or HTTP, the login phpMyAdmin requires a data username and password to authenticate, as follows:
PHP installation mode is Apache, you can use HTTP and cookies;
The PHP installation mode is CGI and you can use cookies.
......
$cfg [' blowfish_secret '] = '; The settings for the phrase password (blowfish_secret). If the authentication method is set to a cookie, you need to set the phrase password, set the reason for the password, it is up to you, you can not leave this blank, otherwise you will be prompted with the following image when you sign in phpMyAdmin
Three. Here, the installation has been completed. We can access http://www in the browser. Your domain/phpmyadmin, as shown in the following figure
If you are a Windows IIS, we can refer to the phpMyAdmin Graphics tutorial in IIS http://www.111cn.net/sys/Windows/45654.htm