Connect MySQL error access denied for user ' root ' @ ' localhost ' (using password:yes) workaround

Tag: The database SQL error is not password-free change command line password

1. Open the My.ini file in the MySQL directory, add a line "Skip-grant-tables" (Password-free login) at the end of the file, save and close the file, and restart the MySQL service.

2. Enter the MySQL bin directory via the command line, type "Mysql-u root-p" (without entering the password) and enter the database.

3. Execute "use MySQL;", using MySQL database.

4. Change Password: Execute "update mysql.user set Authentication_string=password (' root ') where user= ' root '" (There is no password this field under the newly installed MySQL5.7 database, the password field is changed to authentication_string).

5. Open the My.ini file in the MySQL directory, delete the last line of "Skip-grant-tables", save and close the file. Restart the MySQL service and enter "Mysql-u root-p root" on the command line to successfully connect to the database.

Then login SQLyog error, error number 1862:your password has expired. Workaround access to database input via command line
mysql> SET PASSWORD = PASSWORD (' root '); Problem solving.

Connect MySQL error access denied for user ' root ' @ ' localhost ' (using password:yes) workaround