MySQL Error 1045 (28000): Wrong resolutionListen to the Voice
- |
- Browse:54286
- |
- Updated: 2018-02-23 14:34
- |
- Tags:mysql
Step through Reading
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
Tools/Materials
Method/Step
-  
Locate the configuration file My.ini and then open it. You can choose to open the
- with Notepad,
When the search mysqld keyword
is found, Add Skip-grant-tables below mysqld to save the exit.
PS: If prompted not to save, you can cut the file to the desktop, change save and then copy to the MySQL directory
-  
After saving, restart MySQL
-  
Then run cmd
Enter mysql-u root-p to log in without a password, Appear password: When the direct return can enter.
- 5
1. Go to MySQL database:
mysql> use mysql;database changed
2. Set a new password for the root user, and the blue part itself input:mysql> Update user set Password=password ("123456") where user= "root"; Query ok, 1 rows Affected (0.04 sec) rows matched: 1 changed: 1 warnings:0
3. Refresh Database mysql> Flush PR Ivileges; Query OK, 0 rows affected (0.01 sec)
4. Exit mysql:mysql> Quitbye
ps:123456 for the new password, users can change their own password according to their own needs
MySQL Error 1045 and 2058 (28000): Error resolution