Login the MySQL database: Error 1045 Error (pictured), suggests that the input user name or password Error denied access,

MySQL error as shown in figure: 1045

/plain view plain copy
ERROR 1045 (28000) : Access denied for user 'root' @ 'localhost' (using password: YES)

I checked a lot of tutorials on the Internet, found that most bosses give solution is to stop the MySQL service, and then in my MySQL configuration file. The ini file to add a bunch of code (code can check it on the website) to skip the MySQL login password authentication process,
But small make up find new versions of mysql is not of this file, and refer to the content of the configuration file on the Internet, their configuration once again under the [mysqld] piece add to skip verification code, restart the mysql service, found that there is no use,


Then to comb again on some of the MySQL command at the command prompt, 2059 mistakes found in navicat MySQL connections (MySQL has a problem with the way navicat validation) enter the following command will password changed just installing a MySQL "root" (the default password is empty or root) :

The ALTER USER 'root' @ 'localhost' IDENTIFIED BY 'password' password EXPIRE NEVER

This command will verify that the password change to the password

Thought is a simple modification rules unexpectedly changed authentication password


So the problem solved!

CodePudding user response:

Hello, have a map? Because I now have been the mistakes

CodePudding user response:

Have generally copied their online tutorials, may unwittingly changed password, suggest you enter your MySQL on the terminal

CodePudding user response:

So, thank you very much for the building! Tried ten thousand kinds of modified ini file is useless,

CodePudding user response:

Thanksgiving!!!!! Really solve the problem!