数据库修改密码的几种方法
1、alter user ‘root’@‘localhost’ identified by ‘123’;
2、set password for ‘root’@‘localhost’=password(‘123’);
3、SET PASSWORD = PASSWORD(‘newpasswd’);
4、ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘123456’;
四种方法总有一种有效!!!