1. 授权数据表(database_name.table_name)所有的权限给'user'@'localhost'
GRANT ALL ON database_name.table_name TO 'user'@'localhost';
ALL包含的权限类型如下:SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER
2. 授权SUPER权限给'user'@'localhost'
GRANT SUPER ON *.* TO 'user'@'localhost';
3. 授权存储过程(database_name.procedure_name)权限给'user'@'localhost'
GRANT EXECUTE ON PROCEDURE database_name.procedure_name TO 'user'@'localhost';
4. 授权函数(database_name.function_name)权限给'user'@'localhost'
GRANT EXECUTE ON FUNCTION database_name.function_name TO 'user'@'localhost';
5. 撤回权限(REVOKE)
REVOKE EXECUTE ON PROCEDURE database_name.procedure_name FROM 'user'@'localhost';
6. 查看'user'@'localhost'的权限
SHOW GRANTS FOR 'user'@'localhost';