MySQL5.7和MySQL8的区别及用户登录创建授权

grant all privileges on *.* 'user'@'%' identified by '123456';

create user 'user'@'%' identified by '123456';
grant all privileges on *.* to 'user'@'%';

show variables like 'default_authentication_plugin';

alter user 'user'@'%' identified with mysql_native_password by '123456';

grant insert,delete,update,select on testdb.* to 'role_name';

revoke insert on testdb.* from 'role_name';

grant 'role_name' to 'user';

set role 'role_name';