MySQL Error 1045 and 2058 (28000): Incorrect resolution

MySQL Error 1045 (28000): Wrong resolutionListen to the Voice

• |
• Browse:54286
• |
• Updated: 2018-02-23 14:34
• |
• Tags:mysql

• 1
• 2
• 3
• 4
• 5
• 6
• 7

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

• Windows 8
• Mysql

Method/Step

1.  

   Locate the configuration file My.ini   and then open it. You can choose to open the

2.   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

3.  

   After saving, restart MySQL

4.  

   Then run cmd

   Enter mysql-u root-p to log in without a password, Appear password: When the direct return can enter.

5. 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