Mysql suddenly fails to log on to the console. the error 1045 is returned.
Source: Internet
Author: User
Mysql was suddenly unable to log on to the console. The 1045 error is that the wamp integration package is used. You like to use command lines when using mysql. 1045 ERROR suddenly reported today: ERROR & nbsp; 1045 & nbsp; (28000): & nbsp; Access & nbsp; denied & nbsp; for & nbs mysql cannot log on to the console suddenly due to error 1045
I use the wamp integration package.
You like to use command lines when using mysql. A 1045 error was reported suddenly today:
ERROR 1045 (28000): Access denied for user 'root' @ 'localhost
However, phpmyadmin can be used.
And all applications can run.
It is depressing that mysql cannot be entered through command lines.
My username is root, and the password is empty. Let me see what the problem is.
------ Solution --------------------
If the user name and password are correct, it must be that root does not allow remote login, or can only log on to a certain ip address. Log on to phpmyadmin, go to the mysql database user table, change the root user's host field to %, and flush privileges.
------ Solution --------------------
Check whether your mysql service is running.
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.