Mysql8数据库用户授权操作

by fplei
Linux,

1.登录有权限或者超级管理员账号****
mysql -uroot -p

2.授权某数据“增，删，改，查”操作给某个用户

授权
GRANT SELECT, UPDATE, DELETE, INSERT ON dbName.* TO 'userName'@'%' WITH GRANT OPTION;
刷新权限
FLUSH PRIVILEGES;

3.授权某个数据库所有权限给某个用户

授权
GRANT ALL PRIVILEGES ON dbName.* TO 'userName'@'%'  WITH GRANT OPTION;
刷新权限
FLUSH PRIVILEGES;

4.撤销用户授权

撤销授权
REVOKE ALL PRIVILEGES on dbUserName.* from userName@'%'
刷新权限
FLUSH PRIVILEGES;