mysql用户及权限常用命令

新建用户

CREATE USER 'userName'@'192.168.0.2' IDENTIFIED BY 'password';

全执行权限

GRANT ALL PRIVILEGES ON * . * TO 'userName'@'192.168.0.2' IDENTIFIED BY PASSWORD 'password' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0

指定库全执行权限

GRANT ALL PRIVILEGES ON `databaseName` . * TO 'userName'@'192.168.0.2' WITH GRANT OPTION ;

指定库--部分权限
//创建权限

GRANT SELECT , UPDATE , INSERT , DELETE ON `cms` . * TO 'userName'@'192.168.0.2';

//删除权限

REVOKE SELECT , UPDATE , INSERT , DELETE ON `cms` . * FROM 'userName'@'192.168.0.2';

删除了整个用户及其权限（包括数据字典中的数据）

DROP USER 'userName'@'192.168.0.2';