公司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