MySQL－EAT, PLAY & EAT!

Oct 06 Wed 2010 19:23
MySQL

Forget password

先停止mysql
/usr/local/etc/rc.d/mysql-server stop killall -q mysqld
進入mysql安全模式
mysqld -u root --skip-grant-tables & mysql
進入以後以mysql的指令去更新root密碼
use mysql UPDATE user SET password = password('新密碼') where user = 'root'; FLUSH PRIVIEGES;