创建用户
#ip限制:
#具体ip '192.168.1.229'
#使用子网掩码 '192.168.0.0/255.255.0.0'
#使用通配符 "192.168.\%.\%"
CREATE USER 'clearwind'@'192.168.137.238' IDENTIFIED BY 'clearwind';
删除用户
drop user 'clearwind'@'192.168.0.0/255.255.0.0';
查看用户
use mysql;
select user,host from user;
授予权限
GRANT select ON `lgfrk`.* TO 'clearwind'@'%';
撤销权限
REVOKE 权限 ON 数据库.表 FROM '用户名'@'登录的ip';
查看用户权限
show grants for 'clearwind'@'%';
修改密码
ALTER USER '用户名'@'登录ip限制' IDENTIFIED BY '密码';
刷新权限
flush privileges;
授予所有权限
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
MySQL创建一个root权限的账号
CREATE USER 'root'@'localhost' IDENTIFIED BY 'XXXXXXXX';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'XXXXXXXX' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;
flush privileges;