※ 引述《[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有跑起來,
then,
mysqladmin -u root -p password "xxxxxx"
(不知道有沒有記錯,用ports安裝的好像有預設 ""的密碼)
預設密碼按enter就ok
--
0000000: 4865 6c6c 6f2c 776f 726c 642e 4974 2069 Hello,world.It i
0000010: 7320 4343 5520 436f 6d6d 2773 2042 4253 s CCU Comm's BBS
0000020: 3a31 3339 342e 7477 6262 732e 6f72 672e :1394.twbbs.org.
0000030: 2f3f 1b3f 2140 2324 6664 6a6b 6c73 6432 /?.b?!@jk?1jk11;
[+] Host : Adios ,[+] SA : 211.75.241.244