MySQL 1045 bug fix

Error List:

ERROR 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:no)

ERROR 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:yes)

Mysqldump:got Error:1045:access denied for the user ' root ' @ ' localhost ' (using password:yes) when trying to connect

Summarize:

MySQL 1045 error: No permissions

Solution:

Skip permissions, reset password, refresh permissions table, restart MySQL

Steps to resolve:

1. Skip Permissions

1.1 Add skip-grant-tables under MySQL config file (linux-->my.cnf) [mysqld], i.e. you can log in without a password.:

1.2 Restarting MySQL

2. Reset Password and Refresh permissions table

Key operations:

Reset Password: Update user set Password=password ("password") where user= "root";

Refresh Permissions table: Flush privileges;

Specific operation:

Note Skip-grant-tables in the MySQL configuration file

3. Restart MySQL

Write a blog to record interest drops.

Hope that the experts have a lot of advice!

MySQL 1045 bug fix