mysql 修改密码

mysql8.0以前修改密码

update user set password=password('123456') where user='root';

flush privileges;

mysql8.0后修改密码

update user set authentication_string='' where user='root';
flush privileges;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';