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

This article mainly introduces the phpmyadmin 1045 error can not log on to the MySQL server solution, has a certain reference value, friends in need can refer to. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

Phpmyadmin 1045 error can not log in to the MySQL server solutions: 1, make sure that the MySQL user name and password are correct, and log in again; 2, log in with the root account and empty password that comes with MySQL by default; 3, modify the HOST host to [%] and save, restart the MySQL database.

Solution to phpmyadmin 1045 error unable to log on to MySQL server:

1. 1045 error caused by MySQL username or password error

The MySQL 1045 error may be caused by an incorrect MySQL username or password. Please make sure that the MySQL username and password are correct and log in again.

2. 1045 error message caused by the failure to set the MySQL password successfully

The MySQL password is not set successfully. You can try to log in using the root account + empty password that comes with MySQL by default.

If login with an empty password is prohibited, use the following method:

Modify the file: / phpmyadmin/libraries/config.default.php

Modify the config.default.php file and find the following two lines of code:

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

Change the false of the first two lines of code to true and change $cfg ['Servers'] [$I] [' password'] =';.

After configuration, log in with root account and empty password, and change the password after login.

Alternatively, you can change the MySQL password through the SSH client, file path: / usr/local/mysql/bin

3. 1045 error reports due to root user rights problems

It may be caused by root user rights. Open the user table in the MySQL database, the HOST host of the root user is localhost, modify the HOST host to% and save, and restart the MySQL database.

Thank you for reading this article carefully. I hope it will be helpful for everyone to share the solution of the phpmyadmin 1045 error unable to log on to the MySQL server. At the same time, I also hope that you will support us, pay attention to the industry information channel, and find out if you encounter problems. Detailed solutions are waiting for you to learn!

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.