mysql常用操作

mysql 管理常用操作

用户权限

用户创建

create user user_name identified by 'password';

查看权限

show grants for user_name;

用户权限变更

grant create,select,insert,delete,update on database.* to user_name@'%' identified by 'password';

删除用户

DROP USER user_name@'%';