mysql密码重置

环境ubuntu server

 

1.停掉mysql： /etc/init.d/mysql stop

2.安全模式启动：/usr/bin/mysqld_safe --skip-grant-tables

3.重置密码

use mysql;

SET PASSWORD FOR 'username'@'%'=PASSWORD('password');

或

UPDATE mysql.user SET Password=PASSWORD('password')

WHERE User='username' AND Host='%';

 

flush privileges;

 

---

需要服务器root账户访问权限