My MySQL is installed through Yum, with version 5.1.73.
Access denied for user ' root ' @ ' localhost ' (using Password:yes) is present in the remote login MySQL command line today, but can be accessed normally in SQLyog and Java programs.
Toss for an hour, the solution is as follows:
1. Stop MySQL Services: Service mysqld stop
2. When you start the MySQL service, take the parameters: Service mysqld start--skip-grant-tables
Skip-grant-tables This parameter literally means skipping the authorization table, which is the user table in the MySQL database. I was going to add this parameter, first without the password to login to MySQL, but did not expect the password.
After entering the correct password, the login is successful. Then the service MySQL restart, everything is OK.
mysql5.1.73 Access denied for user ' root ' @ ' localhost ' (using Password:yes)