linux下mysql重置密码

# 重置密码 (第一步跳过mysql的密码认证过程)
# vim /etc/my.cnf(注：windows下修改的是my.ini)
# 在文档中搜索mysqld定位到[mysqld],在后面任意一行添加skip-grant-tables，如下：
[mysqld]
skip-grant-tables
#保存并退出
#重启mysql
# systemctl restart mysqld
# mysql -uroot
#接下来开始修改密码

#mysql修改密码报错解决办法？
mysql> update user set password=password('newpassword') where user='root';

错误：The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

#关掉新主库的只读属性
mysql> set global read_only=0;
mysql> flush privileges;
mysql> set global read_only=1;
mysql> flush privileges;
mysql> alter user 'root'@'localhost' identified by  'newpassword';