mysql数据库密码破解_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 stopservice mysqld start