Is like that, I log in mysql, direct input the correct password prompt my ERROR 1045 (28000) : Access denied for user 'root' @ 'localhost' (using password: YES) I began to think that is the wrong password, and then back to empty root passwords and then reset
Steps 1. Stop the service administrators run CMD with mysqld, console, skip - grant - tables - Shared - memory to start the service,
2. The service starts to empty the mysql password login system. Exe -u root and then execute SQL command sets the root password to empty the UPDATE mysql. The user SET authentication_string='WHERE the user=' root 'and the host=' localhost '
3. Then reset password set permissions to restart service
Then I'm using a modified password but still hint my ERROR 1045 (28000) : Access denied for user 'root' @ 'localhost' (using
Great god told that this is how to return a responsibility, isn't it the problem of the password??????

CodePudding user response:

Mysql8.0 slightly difference with the previous versions password mechanism,
The alter user 'root' @ 'localhost' identified with mysql_native_password by 'password'.
Try again

CodePudding user response:

I also encountered this problem today, tried many methods, finally found a viable! You can refer to
https://blog.csdn.net/qq_39262705/article/details/84569385