※ 引述《[email protected] (Strategist)》之銘言:
> ==> 在 "法蘭斯" <[email protected]> 的文章中提到:
> > mysqladmin -u root -p password "xxxxxx"
> > mysqladmin -u root password "xxxxxx"
> > 這兩個意思不一樣
> > mysqladmin -u root password "xxxxxx"
> > 設定密碼
> > mysqladmin -u root -p password "xxxxxx"
> > 更改密碼,而需輸入原密碼。初始安裝者,原密碼是 ""
> 這是指出現Enter password:時直接按enter,right?
> 我直接按enter出現下列error message
> mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: 'root@localhost' (Using password: NO)'
> 是在connect時就掛了:~
> 看起來是不給root連
> 請前輩再給點指點吧
> Thanks in advance!
重設 MySQL root 密碼:
/usr/local/etc/rc.d/mysql-server.sh stop
safe_mysqld --skip-grant-tables &
mysql -u root -p mysql
update user set password=password('newpassword') where user='root';
flush privileges;
\q
/usr/local/etc/rc.d/mysql-server.sh stop
/usr/local/etc/rc.d/mysql-server.sh start
--
好康訊息!
Openfind 提供免費撥接電話:40508888
帳號:openfind 密碼:openfind
--
http://bbs.openfind.com.tw
※來源:192.83.*