Mysql ERROR 1045 (28000): ERROR solution, 104528000
ERROR 1045 (28000): Access denied for user 'odbc '@ 'localhost' (using password: NO)
ERROR 1045 (28000): Access denied for user'ODBC'@ 'Localhost' (using password: YES)
In windows, the solution to the preceding two errors is verified by myself. The solution is as follows:
1. Find the configuration file my. ini and open it. You can choose to open it in notepad.
2. Search for the mysqld keyword. After finding it, add skip-grant-tables under mysqld, save and exit. PS: if you do not want to save the file, you can cut it to the desktop, save it, and copy it to the mySQL directory.
3. Save and restart mySQL.
4. Run cmd and enter mysql-u root-p to log on without a password. If password: is displayed, press enter to enter.
5. Enter the mysql database:
PS: 123456 is the new password. You can change it to your own password as needed.
6. After modification, modify the my. ini file, delete the "skip-grant-tables" line we just added, save and quit, and restart mysql.