USAGE
Synonym for “no privileges”
The EVENT
and TRIGGER
privileges were added in MySQL 5.1.6. A trigger is associated with a table, so to create or drop a trigger, you must have the TRIGGER
privilege for the table, not the trigger. (Before MySQL 5.1.6, the SUPER
privilege was required to create or drop triggers.)
创建全局用户：
GRANT ALL ON *.* TO 'someuser'@'somehost';
GRANT SELECT, INSERT ON *.* TO 'someuser'@'somehost';
GRANT ALL ON *.* TO
[email='someuser'@'somehost']'someuser'@'somehost'[/email]
;
GRANT SELECT, INSERT ON *.* TO
[email='someuser'@'somehost']'someuser'@'somehost'[/email]
;
但是 CREATE USER
, FILE
, PROCESS
, RELOAD
, REPLICATION CLIENT
, REPLICATION SLAVE
, SHOW DATABASES
, SHUTDOWN
, and SUPER
这些权限只能全局地赋权限。
数据库级别的：
GRANT ALL ON mydb.* TO
[email='someuser'@'somehost']'someuser'@'somehost'[/email]
;
GRANT SELECT, INSERT ON mydb.* TO 'someuser'@'somehost';
表级别的：
GRANT ALL ON mydb.mytbl TO 'someuser'@'somehost';
GRANT SELECT, INSERT ON mydb.mytbl TO
[email='someuser'@'somehost']'someuser'@'somehost'[/email]
;
列级别的：
GRANT SELECT (col1), INSERT (col1,col2) ON mydb.mytbl TO
[email='someuser'@'somehost']'someuser'@'somehost'[/email]
;
存储过程：
有这 ALTER ROUTINE
, CREATE ROUTINE
, EXECUTE
, and GRANT OPTION
几种权限。
GRANT CREATE ROUTINE ON mydb.* TO
[email='someuser'@'somehost']'someuser'@'somehost'[/email]
;
GRANT EXECUTE ON PROCEDURE mydb.myproc TO 'someuser'@'somehost';
查看用户的权限：
show grants for 你的用户
比如：
show grants for root@'localhost';