本文共 816 字,大约阅读时间需要 2 分钟。
CREATE USER 'username'@'host' IDENTIFIED BY 'password';
# 本机访问CREATE USER 'test'@'localhost' IDENTIFIED BY '123456';# 允许192.168.1.*IP段访问CREATE USER 'test'@'192.168.1.%' IDENDIFIED BY '123456';# 远程连接CREATE USER 'test'@'%' IDENTIFIED BY '123456';
show grants for root@localhost;
grant select,insert,update,delete,create,drop on databasename.tablename to 'username'@'host' identified by 'username';
grant select,insert,update,delete,create,drop student.* to 'test'@'%' identified by 'test';
revoke create,drop on databasename.tablename from 'username'@'%';
REVOKE create,drop ON test.* FROM 'test'@'%';
转载地址:http://kpzsi.baihongyu.com/