Using PHP and MySQL development site, phpMyAdmin is a very friendly MySQL management tool, and free open source, many domestic virtual hosts have their own management tools, configuration is simple, Next, configure phpMyAdmin on the Linux server to manage the MySQL database
First Visit phpMyAdmin homepage, the URL is: http://www.phpmyadmin.net/, enter after the download button, do not download, because the download is the ZIP package of windows, click the download link in the navigation bar, Go to the download screen, download the latest version of 4.5.5.1, select the version to download:
Download it and upload it to the server, then perform the following command to unzip it:
TAR-XVZF phpmyadmin-4.5. 5.1-all-languages. tar.gz
After the decompression is complete, we put it into a directory that can be accessed by the web, followed by convenient management, such as/home/wwwroot
MV phpmyadmin-4.5. 5.1-all-languages/home/wwwroot/
Then execute cd/home/wwwroot/and then rename the phpMyAdmin directory, try not to let others guess the entrance, such as:
MV phpmyadmin-4.5. 5.1-all-languages phpmyadmina4689f
Then execute the CD phpmyadmina4689f into the installation directory, the latest version of the phpMyAdmin support fast configuration, do not have to execute the installation script, the official rapid installation of Chinese documents: http://docs.phpmyadmin.net/zh_CN/ Latest/setup.html#quick-install
At this point you can see a configuration file under the directory: config.sample.inc.php
Make a copy of this file:
CP config.sample.inc.php config.inc.php
Then perform the edit:
Vim config.inc.php
Find $cfg[' blowfish_secret ' configuration items, followed by default is empty, here we can arbitrarily set a complex string, used to encrypt the use:
Then $cfg[' Servers ' [$i] [' auth_type '] This default is a cookie, indicating that each time you want to log in, we do not have to modify, so it is more secure, and then $cfg[' Servers ' [$i] [' host '] = ' 127.0.0.1 It is recommended to set the IP address, whether local or remote as long as the MySQL authorization is no problem, the default localhost may appear #2002-permission denied-the server is not responding such errors, It is important to note that IP addresses are recommended
If the local debugging, then this is set to config, and then fill in the user name and password here, each time automatically entered, debugging more convenient
Overall is to set the above login authentication type and IP address a total of two items, set to complete the Save and exit, and then through the Web Access to our phpMyAdmin directory address, such as put in www.xxxx.com, then we need to visit:/http www.xxxx.com/phpmyAdmina4689f, note that the Linux server is strictly case-sensitive, this time to see the login interface, phpMyAdmin is configured
Blank password login is forbidden (see Allow blank password)
Null password logon is forbidden (see allow null password) for similar errors. You want to modify the. /phpmyadmin/libraries/config.default.php file, locate the following two lines
$cfg [' Servers '] [$i] [' nopassword '] = false;
$cfg [' Servers '] [$i] [' allownopassword '] = false;
Change two false to true and set it up $cfg[‘Servers‘][$i][‘password‘] = ‘‘
; phpMyAdmin will allow a blank password to log in to the MySQL database after the configuration file is set. If you re-login to phpmyadmin with a blank password, you may still not be able to log in, please clear the cookie or close the original phpMyAdmin login window and re-login with a blank password. If this time still shows the blank password login is forbidden, try to enter a few characters as a password to see if the landing is successful. Log in to MySQL server and change the MySQL password in phpMyAdmin as soon as possible.
Configure phpmyadmin--to allow blank passwords on Linux servers