环境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账户访问权限