MySQL帐号操作

查看当前用户

select current_user();

创建帐号

# 创建只允许本地访问的帐号
`create user 'sgfoot'@'localhost' identified by 'sgfoot';`
# 创建只允许192.168开头的ip访问的帐号
`create user 'sgfoot'@'192.168.%.%' identified by 'sgfoot';`
# 创建任意ip访问的帐号
`create user 'sgfoot'@'%' identified by 'sgfoot';`

查看所有的帐号

select host, user, password from user

帐号授权

格式: grant 权限 on 数据库.* to 用户名@登录主机 identified by "密码";

# 授权select, insert, update,delete
grant select,insert, update,delete on hello.* to 'sgfoot'@'localhost';

查看某用户权限

show grants for 'sgfoot'@'localhost';

取消权限

格式: revoke 权限 on 数据库.表名 from 用户名@登陆主机

revoke all on *.* from sgfoot@localhost;

修改权限

grant all on *.* to 'sgfoot'@'%';

刷新权限

flush privileges;

删除帐号

drop user sgfoot@localhost