授权表 | 内容 |
user | 能连接服务器的用户以及他们拥有的任何全局权限 |
db | 数据库级权限 |
tables_priv | 表级权限 |
columns_priv | 列级权限 |
GRANT privileges (columns) ON what TO user IDENTIFIED BY "password" WITH GRANT OPTION |
privileges |
权限指定符 | 权限允许的操作 |
ALTER | 修改表和索引 |
CREATE | 创建数据库和表 |
DELETE | 删除表中已有的记录 |
DROP | 抛弃(删除)数据库和表 |
INDEX | 创建或抛弃索引 |
INSERT | 向表中插入新行 |
REFERENCE | 未用 |
SELECT | 检索表中的记录 |
UPDATE | 修改现存表记录 |
FILE | 读或写服务器上的文件 |
PROCESS | 查看服务器中执行的线程信息或杀死线程 |
RELOAD | 重载授权表或清空日志、主机缓存或表缓存 |
SHUTDOWN | 关闭服务器 |
ALL 所有;ALL PRIVILEGES | 同义词 |
USAGE | 特殊的“无权限”权限 |
GRANT ALL ON samp_db.* TO boris@localhost IDENTIFIED BY "ruby"GRANT ALL ON samp_db.* TO fred@res.mars.com IDENTIFIED BY "quartz" |
GRANT ALL ON samp_db.* TO max@% IDENTIFIED BY "diamond" |
GRANT ALL ON samp_db.* TO [email=mary@.snake.net]mary@.snake.net[/email] IDENTIFIED BY "quartz"; |
GRANT ALL ON samp_db.* TO boris@192.168.128.3 IDENTIFIED BY "ruby" GRANT ALL ON samp_db.* TO fred@192.168.128.% IDENTIFIED BY "quartz" GRANT ALL ON samp_db.* TO rex@192.168.128.0/17 IDENTIFIED BY "ruby" |
GRANT ALL ON samp_db.president TO "my friend"@"boa.snake.net" |
GRANT ALL ON *.* TO ethel@localhost IDENTIFIED BY "coffee" WITH GRANT OPTION |
GRANT RELOAD ON *.* TO flushl@localhost IDENTIFIED BY "flushpass" |
GRANT ALL ON samp_db TO bill@racer.snake.net INDETIFIED BY "rock" GRANT SELECT ON samp_db TO ro_user@% INDETIFIED BY "rock" |
GRANT SELECT,INSERT,DELETE,UPDATE ON samp_db TO bill@snake.net INDETIFIED BY "rock" |
GRANT SELECT ON samp_db.member TO bill@localhost INDETIFIED BY "rock"GRANT UPDATE (expiration) ON samp_db. member TO bill@localhost |
GRANT UPDATE (street,city,state,zip) ON samp_db TO assistant@localhost |
GRANT ALL ON tmp.* TO ""@mars.net |
GRANT ALL ON sales.* TO alicia@%.big.corp.com INDETIFIED BY "applejuice" WITH GRANT OPTION |
REVOKE privileges (columns) ON what FROM user |
%mysql -u root mysql mysql>DELETE FROM user ->WHERE User="user_name" and Host="host_name"; mysql>FLUSH PRIVILEGES; |
欢迎光临 MariaDB社区 (http://123.56.88.72/) | Powered by Discuz! X3.2 |