今天突然被老闆告知他想測一下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)'
再嘗試另一個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>