数据库账号权限赋予与取消

数据库账号权限赋予
GRANT PRIVILEGES ON db.table TO username@host IDENTIFIED BY password WITH GRANTOPTION;

例子：GRANT SELECT ON *.* TO 'spring'@'%' IDENTIFIED BY'l82z@95awe' WITH GRANT OPTION;

数据库账号权限取消

REVOKE PRIVILEGES ON db.table FROM username@host;

例子：REVOKE SELECT ON *.* FROM 'spring'@'%' ;

取消权限语句需要与赋予权限语句中账号的权限保持一致完全相同