解決MySQL安裝時(shí)1045錯(cuò)誤的方法

該錯(cuò)誤只在Windows系統(tǒng)上出現(xiàn)，Linux下好像好沒(méi)有，據(jù)說(shuō)這個(gè)錯(cuò)誤已經(jīng)存在n年了，有人extremely dispointed that it still exists here in 2009!

錯(cuò)誤的原因更令人抓狂，那就是mysql server instance config wizard根本沒(méi)有為你設(shè)密碼，于是root密碼是空！實(shí)在不明白如果沒(méi)有為我設(shè)密碼那中間為什么叫我設(shè)個(gè)密碼。
-
 

解決辦法：

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: 國(guó)內(nèi)和國(guó)外的水平真是差得遠(yuǎn)，國(guó)內(nèi)的磚家們只會(huì)告訴你是和以前安裝的mysql版本沖突了，把它卸干凈，再把配置啊注冊(cè)表啊都刪干凈（簡(jiǎn)直就是既然我不知道是哪錯(cuò)了那就是全錯(cuò)了），再重裝。而問(wèn)題根本沒(méi)解決。。。。。。人國(guó)外的卻能一針見(jiàn)血地指出問(wèn)題之所在。

服務(wù)器租用/服務(wù)器托管中國(guó)五強(qiáng)！虛擬主機(jī)域名注冊(cè)頂級(jí)提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]