mysql8.0 创建用户和授予权限

创建和赋予权限

 create user 'username'@'%' identified by 'password';

ALTER USER 'username'@'%' IDENTIFIED WITH mysql_native_password BY 'password';

grant all privileges on *.* to 'username'@'%' ;
FLUSH PRIVILEGES;

撤销权限

-- 撤销update权限
revoke update on simpleshop.* from 'username'@'%'
-- 撤销所有权限
revoke all on simpleshop.* from 'username'@'%' ;