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

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

MySQL installation of the default user is root, where the root refers to the database users, root password generally in the initialization of MySQL in your log file, log file storage path can be customized through the my.cnf file.

This can be solved using the following method, which has been verified.

#1. Stop the MySQL database/etc/Init.d/mysqld Stop #2. Execute the following command Mysqld_safe--user=mysql--skip-grant-tables--skip-networking & #3. Log in to MySQL database with root MySQL-u root MySQL #4. Update the root password MySQL> UPDATE User SETPassword=PASSWORD ('NewPassword')where USER='Root'; #最新版MySQL请采用如下SQL: MySQL> UPDATE User SETAuthentication_string=PASSWORD ('NewPassword')where USER='Root'; #5. Refresh Permissions MySQL>FLUSHPrivileges; #6. Exit Mysqlmysql>Quit #7. Restart MySQL/etc/Init.d/mysqld Restart #8. Log back in mysqlmysql with the root user-Uroot-p Enter Password:<Enter the newly created password NewPassword>

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