删除用户
flush privileges;
drop user '用户名';
添加用户
create user '用户名'@'%' identified by '密码';
授权
GRANT SELECT ON 数据库名.表名 TO '用户名'@'%' IDENTIFIED BY '密码';
GRANT SELECT, INSERT, UPDATE, DELETE ON 数据库名.表名 TO '用户名'@'%' IDENTIFIED BY '密码';
GRANT ALL PRIVILEGES ON 数据库名.* TO '用户'@'%' IDENTIFIED BY '密码';
GRANT SELECT 是授予select权限,还可以授其他权限。
权限包括:
数据库表table的增删改:create ,alter ,drop
操作外键、索引权限:reference ,index
操作临时表、视图权限:create temporary tables,create view,show view
操作存储过程、函数权限:create routine,alter routine,execute
全部权限:all privileges
刷新权限
flush privileges;