mysql8.0 常用sql语句

CREATE DATABASE mros DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

select host,user,authentication_string,plugin from user;

Delete FROM user Where User='test' and Host='localhost';

create user 'test'@'%' identified by '123456';

grant all privileges on *.* to 'test'@'%' with grant option;
Delete FROM user Where User='liu' and Host='%';

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER; #修改加密规则
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456'; #更新一下用户的密码

FLUSH PRIVILEGES; #刷新权限

再重置下密码：alter user 'root'@'localhost' identified by '123456';