Recently logged on to a server MySQL total error:
Access[[email protected] ~]# mysql-u root-p
Enter Password:
ERROR 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:no) denied for user ' root ' @ ' localhost ' (usi ng Password:no)
I wonder if the password is forgotten ... Then prepare to change the password:
#mysqladmin-u root-p password 123456 # # #设置root密码为123456
Enter Password:
Mysqladmin:connect to server at ' localhost ' failed
Error: ' Access denied for user ' root ' @ ' localhost ' (using Password:yes) '
Still reported this error ... The egg hurts, Baidu a bit, finally found the method as follows:
Method One:
#/etc/init.d/mysqld Stop
# Mysqld_safe--user=mysql--skip-grant-tables--skip-networking &
# mysql-u Root MySQL
mysql> UPDATE user SET Password=password (' NewPassword ') where user= ' root ';
mysql> FLUSH privileges;
Mysql> quit
#/etc/init.d/mysqld Restart
# mysql-uroot-p
Enter Password: < Enter the newly set password newpassword>
Mysql>
Method Two:
Use the user name and password provided directly in the [client] section of the/etc/mysql/debian.cnf file:
# mysql-udebian-sys-maint-p
Enter Password: < Enter the password for the [client] section >
mysql> UPDATE user SET Password=password (' NewPassword ') where user= ' root ';
mysql> FLUSH privileges;
Mysql> quit
# mysql-uroot-p
Enter Password: < Enter the newly set password newpassword>
Mysql>
Method Three:
This method I have not been tested, because my root user default password has been modified by me, the person has time to test, the results told me, thank you!
# mysql-uroot-p
Enter Password: < Enter the password provided in the [Client] section of the/etc/mysql/debian.cnf file >
At this point, the problem solved a long puzzle!
MySQL Login error "Access denied for user ' root ' @ ' localhost ' (using Password:yes" processing method)