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)