==> 在 [email protected] (Advanced Perl) 的文章中提到:
> ※ 引述《[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)'
> > 再嘗試另一個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'
> > 請有經驗的前輩幫一下忙吧...
> sockstat -4l
> 先確定mysql-server有跑起來,
應該有跑起來
mysql mysqld 162 5 tcp4 *:3306 *:*
root sendmail 104 4 tcp4 *:25 *:*
root sendmail 104 6 tcp4 *:587 *:*
root sshd 99 4 tcp4 *:22 *:*
root syslogd 88 5 udp4 *:514 *:*
root dhclient 70 4 udp4 *:68 *:*
> then,
> mysqladmin -u root -p password "xxxxxx"
> (不知道有沒有記錯,用ports安裝的好像有預設 ""的密碼)
> 預設密碼按enter就ok
我下mysqladmin -u root -p password
出現Enter password:
一按enter,出現下列錯誤訊息
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
--
* Post by strategist from telnet.hinet.net
* Origin: ★ 交通大學資訊科學系 BBS ★ <bbs.cis.nctu.edu.tw: 140.113.23.3>