First MySQL8 installation, configure the remote access reference https://blog.csdn.net/xinpengfei521/article/details/80403965, such as change password policy and password after, found that the original password and new password can't login, please advise!

CodePudding user response:

The building Lord, your problem solved? I also encountered the same problem now, is the new password is too simple so banned

CodePudding user response:

To join in. In my CNF to restart
Default_authentication_plugin=mysql_native_password

CodePudding user response:

Modify the MySQL account password, need to pay attention to the following two points:
1. The 'root' @ 'localhost' and 'root' @ '%' is a different account
2. Log in using the -h localhost and do not use the -h, different