JZTXT

Docker 重置mysql密码

发布时间 2023-10-22 23:07:30作者: 一只桔子2233

1、参考

docker重置mysql密码

2、

set password for dev@%='password2';

update mysql.user set authentication_string='password2' where user='dev';


update user set password=password("password2") where user='dev';

flush privileges;

ALTER USER 'dev'@'%' IDENTIFIED WITH mysql_native_password BY 'password2';

drop user 'dev'@'localhost';
drop user 'root'@'localhost';
create user 'dev'@'%' identified by 'password2';
create user 'huibang'@'%' identified by 'password2';