版权声明 ：转载时请以超链接形式标明文章原始出处和作者信息及本声明 http://kerochan.blogbus.com/logs/43381667.html
该错误只在windows系统上出现，据说这个错误已经存在n年了，有人extremely dispointed that it still exists here in 2009!
错误的原因更令人抓狂，那就是mysql server instance config wizard根本没有为你设密码，于是root密码是空！实在不明白如果没有为我设密码那中间为什么叫我设个密码。。。。。。。
解决办法：
I clicked Skip on the dialog that states the Error 1045... Then cancelled the "MySQL Server Instance Config Wizard" Now... Open a command prompt type "mysql -u root -p" then hit enter again when it requests a password. You should now have access to the mysql monitor... type the following at the prompts... mysql>use mysql mysql>select user, host, password from user; # Now you should see that u have 3 entries +----------------------------+ | user | host | password | +-----------------------------+ | root | localhost | | | root | 127.0.0.1 | | | | localhost | | +-----------------------------+ mysql> delete from user where host="localhost" and user=""; mysql> update user set password=password("xxxx") where user="root"; mysql> flush tables; mysql> flush privileges; mysql> quit Now the mysql table should be updated and everything fixed. Try it out... 然后就可以用config wizard跑一遍了。。。 PS: 国内和国外的水平真是差得远，国内的砖家们只会告诉你是和以前安装的mysql版本冲突了，把它卸干净， 再把配置啊注册表啊都删干净（简直就是既然我不知道是哪错了那就是全错了），再重装。 而问题根本没解决。。。。。。人国外的却能一针见血地指出问题之所在。
