Mysql 重設密碼

killall mysqld
/usr/bin/safe_mysqld --skip-grant-tables &
mysql

mysql> use mysql
mysql> UPDATE mysql.user SET Password = PASSWORD('newpassword') WHERE User = 'root';
mysql> FLUSH PRIVILEGES;
mysql> exit;


來源出處