MYSQL权限管理

grant  权限  on 库.表 to 用户名@主机   identified by '密码' with grant option

mysql> grant all privileges on *.* to cj@localhost  identified by 'cj' with grant option;

 

刷新权限

flush  privileges 

 

删除用户

mysql> drop user cc@localhost;

 

查看用户权限

mysql> show grants for cj@localhost;