Configure phpmyadmin--to allow blank passwords on Linux servers

Source: Internet
Author: User
Tags php and mysql

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.