1.mysql8.x版本修改密码:
ALTER USER root@localhost IDENTIFIED BY '123456';
2.mysql5.x版本修改密码:
set password for 用户名@localhost = password('newpassword'); mysqladmin -u用户名 -p旧密码 password 新密码;
1.mysql8.x版本修改密码:
ALTER USER root@localhost IDENTIFIED BY '123456';
2.mysql5.x版本修改密码:
set password for 用户名@localhost = password('newpassword'); mysqladmin -u用户名 -p旧密码 password 新密码;