mysql数据库添加用户及分配权限具体实现_MySQL

insert into mysql.user(Host,User,Password) values("localhost","phplamp",password("1234"));//创建用户 
grant all privileges on dbname.* to &＃39;username&＃39;@&＃39;%&＃39; identified by &＃39;password&＃39;;//创建用户并分配所有权限 
grant select,update on phplampDB.* to phplamp@localhost identified by &＃39;1234&＃39;;//创建用户并分配权限 
update mysql.user set password=password(&＃39;新密码&＃39;) where User="phplamp" and Host="localhost";//修改用户密码

--删除用户指定权限

revoke insert,update,delete,select ON *.* from &＃39;xbb&＃39;@&＃39;localhost&＃39; IDENTIFIED BY &＃39;123&＃39;;

以上就是mysql数据库添加用户及分配权限具体实现_MySQL的内容，更多相关内容请关注PHP中文网（www.php1.cn）！