MySQL Error nr.1045 workaround

Source Address: http://yanshuaijun.2010.blog.163.com/blog/static/362411622011102443056225/ topic: MySQL Error nr.1045 workaround

2011-11-24 16:30:56  | Category: mysql| report | Font Size Subscribe

1. Go to cmd manually stop MySQL service: net stop MySQL.

2. Modify the My.ini file under the 5.1\ directory of the C:\Program files\mysql\mysql Server and add it under [mysqld]
Skip-grant-tables

3. Start the MySQL service in cmd: net start MySQL

4. Open MySQL directly press ENTER to log in with a blank password

5. Quit MySQL, stop MySQL service: net stop MySQL

6, the 2nd step to add the Skip-grant-tables statement deleted

7. Start MySQL service: net start MySQL

8. Open MySQL login with a blank password

9, change the password set password for [email protected]=password (' password '); Password is the password to be set

10, quit MySQL, reconfigure will not appear 1045 error)