==> 在 [email protected] (Deferno) 的文章中提到:
> ※ 引述《[email protected] (Strategist)》之銘言：
> > 今天突然被老闆告知他想測一下MySQL
> > 我就裝了台FreeBSD 4.10 Stable
> > 用CVSup update了source tree跟ports tree
> > 進/usr/ports/databases/mysql40-server/
> > 成功安裝了MySQL
> > 可是再來問題來了，依照MySQL安裝完時的提示要更改root password
> > 卻被禁止連線!!??
> > 我依照說明下了這行command
> > /usr/local/bin/mysqladmin -u root password '1A2b3C'
> > 卻出現下列錯誤訊息
> > /usr/local/bin/mysqladmin: connect to server at 'localhost' failed
> > error: 'Access denied for user: 'root@localhost' (Using password: NO)'
> 先用沒密碼登入吧
> 剛裝好不是都預設沒有密碼嗎@@?(Using password: NO)<==很明白了
我也是記得剛裝好是沒有password的
可是一下"mysqladmin -u root -p password"
卻出現"Enter password:"
按enter，出現下列Error message :<
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
> > 再嘗試另一個command
> > /usr/local/bin/mysqladmin -u root -h FreeBSD.haha.net password '1A2b3C'
> > 也出現下列另一個錯誤訊息...
> > /usr/local/bin/mysqladmin: connect to server at 'FreeBSD.haha.net' failed
> > error: 'Host 'FreeBSD' is not allowed to connect to this MySQL server'
> > 請有經驗的前輩幫一下忙吧...
--
* Post by strategist from telnet.hinet.net
* Origin: ★ 交通大學資訊科學系 BBS ★ <bbs.cis.nctu.edu.tw: 140.113.23.3>