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.

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.