总结

数据库账号权限赋予
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'@'%' ;