Shulou(Shulou.com)06/01 Report--

This article will explain in detail the solution to the failure to log on to the mysql server in phpmyadmin # 1045. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

Phpmyadmin # 1045 error unable to log in to the mysql server solution: change the false of the relevant code in the [/ phpmyadmin/libraries/config.default.php] file to true, and log in with an empty password.

Phpmyadmin # 1045 error failed to log on to the mysql server:

At this time, you can try to log in to the database using the empty password of mysql's default root account.

If you log in with an empty password, an error occurs when logging in with an empty password is disabled (see allowing null passwords). To modify the / phpmyadmin/libraries/config.default.php file, find the following two lines

$cfg ['Servers'] [$I] [' nopassword'] = false;$cfg ['Servers'] [$I] [' AllowNoPassword'] = false

Change the two false to true and set $cfg ['Servers'] [$I] [' password'] = "

By setting the configuration file in this way, phpmyadmin will allow you to log in to the mysql database with an empty password.

Second, if you re-log in with an empty password and phpmyadmin is sometimes unable to log in, please clear cookie or close the original phpmyadmin login window and log in again with an empty password.

If it still shows that an empty password login is prohibited, try entering a few characters as a password to see if you can log in successfully.

Change the mysql password in phpmyadmin as soon as you log in to the MySQL server. Or change the mysql password on the SSH client: cd / usr/local/mysql/bin

Then execute the command:

. / mysqladmin-u root-p password http://laser-mall.com/passwd on "phpmyadmin # 1045 error can not log on to the mysql server solution" this article shares here, I hope the above content can be of some help to you, so that you can learn more knowledge, if you think the article is good, please share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.