MySQL5.7和MySQL8.0以上修改密码的方式

首先进入

mysql -uroot -p

mysql> use mysql

5.7：

mysql> use mysql  
mysql> update user set password=password('root') where user='root'; ```

8.0及以上：

mysql> alter user'root'@'localhost'  identified withmysql_native_password by '新密码'; ```

或者

mysql> alter user'root'@'localhost' identified by '新密码'; ```

最后刷新

mysql> flush privileges;

如果

ERROR 1348 (HY000): Column ‘Password’ is not updatable

可以使用

GRANT ALL PRIVILEGES ON *.* TO 'YourUserName'@'%' IDENTIFIED BY "YourPassword";

or

GRANT ALL PRIVILEGES ON *.* TO 'YourUserName'@'YourIP' IDENTIFIED BY "YourPassword";