mysql數據庫密碼破解

公司mysql dba把數據庫root密碼丟失需要破解，方法如下，適合linux、unix機器

service mysqld stop
 
/opt/mysql/bin/mysqld_safe --skip-grant-tables &
 
/opt/mysql/bin/mysql -u root
 
update mysql.user set password=PASSWORD('...') where User='root' and host='localhost';
 
flush privileges;

service mysql stop
service mysqld start