> update user set password=password('newpassword') where User='root' and host='localhost';
> flush privileges;
然後
% kill `cat mysqld.pid`
重跑 mysql
% /usr/local/etc/rc.d/mysql-server.sh start
--
peace of love~
Alan, Cheng-Lung Sung <clsung AT dragon2 DOT net>
--
◆ 從 localhost 來的水榭訪客
--
自由心靈的天堂§水榭(SungSung.Dragon2.Net)§
照這樣來試看看
先停掉 mysql
% /usr/local/etc/rc.d/mysql-server.sh stop
% safe_mysqld --user=mysql --pid-file=mysqld.pid --skip-grant-tables &
% mysql -u root mysql