mysql root忘记密码重置

1.停止mysql服务

2.

cd /usr/local/mysql/bin

sudo su #切换root

3../mysqld_safe --skip-grant-tables & #启动mysql并忽略认证

4. mysql -uroot #进入mysql

5.FLUSH PRIVILEGES;#首先执行下面命令为了能够修改任意的密码(重要)

6.

  update mysql.user set password=password(‘1') where user='root’;   ## mysql5.5,5.6

update mysql.user set authentication_string=password('1') where user='root';

##mysql5.7,请不要直接复制此命令,可能复制到有格式命令执行不成功

7. FLUSH PRIVILEGES; #重新刷新权限

8.重启mysql,用重置的密码进入,show databases;查看下,如果提示则”You must reset your password using ALTER USER statement”

则再运行下如下:

SET PASSWORD = PASSWORD('1');

Windows 重置也类似