更改MySql密码

有旧密码

无旧密码

1. 在关闭状态:

   systemctl stop mysql

2. 保证有mysqld

   mkdir /var/run/mysqld
   chown mysql /var/run/mysqld

3. 开启无需密码模式

   mysqld_safe --skip-grant-tables& 

4. 进入

   mysql -u root -p

5. 清空旧密码

   UPDATE mysql.user SET authentication_string=null WHERE User='root';
   flush privileges;

6. 更改密码

   ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
   flush privileges;

7. 重启mysql

   systemctl start mysql