ERROR 1045 (28000): Access denied for user ' ODBC ' @ ' localhost ' (using Password:no)
ERROR 1045 (28000): Access denied for user ' ODBC ' @ ' localhost ' (using Password:yes)
Workaround for the above two errors under Windows
1. Locate the profile My.ini, then open it, and choose to open it with Notepad
2, open, search mysqld keyword found, add skip-grant-tables below Mysqld, save exit.
PS: If prompted not to save, you can cut the file to the desktop, change the save and then copy to the MySQL directory
3, Start button +r, open the Run dialog box, enter "Services.msc", open the service window
4. Restart MySQL Service
5, then run cmd, input mysql-u root-p can not login with the password, appear password: When the direct enter can enter.
6. Enter MySQL database:
mysql> Use mysql;database changed
7. Set a new password for the root user:mysql> update user set Password=password ("123456") where user= "root";
Tip: Query OK, 1 rows affected (0.04 sec) rows Matched:1 changed:1 warnings:0
8. Refresh the database mysql> flush privileges;
Tip: Query OK, 0 rows affected (0.01 sec)
9. Exit Mysql:mysql> Exit
Tip: Bye
ps:123456 for the new password, users can change their own password according to their own needs
10, modified, and then modified My.ini this file, we just joined the "Skip-grant-tables" this line to delete, save and restart the MySQL service can be.
MySQL Error 1045 (28000): Wrong resolution