Sql语句语法大全

2. 权限-- 显示权限信息SHOW GRANTS FOR your_username@'localhost'; -- 授予权限GRANT some_privileges ON some_databases(some_tables) TO some_users@'localhost'; -- 撤销权限REVOKE some_privileges ON some_databases(some_tables) FROM some_user@'localhost'; -- 刷新权限FLUSH PRIVILEGES; -- 权限粒度GRANT ALLREVOKE ALLON database_name