Phpmyadmin does not need a password to log on. _ PHP Tutorial

Source: Internet
Author: User
Tags myadmin
Phpmyadmin does not need a password for logon. In the php Tutorial, myadmin does not need a password to log on. after installing phpmyadmin in the latest version, enter the username root and click "log on" (because I am Local, the root has no password) php Tutorial myadmin does not need a password to log on.

The latest phpmyadmin version
After installation, enter the username "root" and click "log on" (because I am Local, the root account has no password)
The result is always an access denied error.
It's okay to check the permission settings,
No good answers are found on the Internet,
The same as the root trace code. The original configuration file config. default. php contains the following sentence:
$ Cfg ['servers'] [$ I] ['allownopasswordroot '] = false;
He was verified in row 886 of libraries/common. inc. php.
If this parameter is set to false, the password cannot be blank if the user name is the root user. Otherwise, the password is not verified. by default, the password is flase. change it to true,
I think this may be for the sake of security. people must set the root password. Oh, but I think it is inconvenient to test it. Generally, local root users are empty.
He can change the prompt statement, saying that your root password is blank and logon is not allowed at the current security level.
You can change the settings at XXX, so you may understand that it is too difficult to find the reason for a single access rejection!


Method 2

./After phpmyadmin is entered, modify the user permission to allow empty password login!

Method 3

By default, empty phpmyadmin passwords are disabled for logon. this line is mainly controlled by two global variables in the configuration file libraries/config. default. php, that is

The code is as follows:
$ Cfg ['servers'] [$ I] ['nopassword'] = false;
$ Cfg ['servers'] [$ I] ['allownopassword'] = false;


If these two variables are set to True, phpmyadmin will allow empty passwords to log on, that is, modifying the values in libraries/config. default. php

The code is as follows:
$ Cfg ['servers'] [$ I] ['nopassword'] = true;
$ Cfg ['servers'] [$ I] ['allownopassword'] = true;


At the same time

The code is as follows:
$ Cfg ['servers'] [$ I] ['password'] = '';

The connection password of the database tutorial is set to null.


The latest version of phpmyadmin is installed, and the user name root is entered, and then the user is clicked to log on (because I am local, so the root has no password...

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.