mysql权限管理

insert into mysql.user(Host,User,Password) values("localhost","enilu",password("1234"));
flush privileges;

create database testdb;
grant all privileges on testdb.* to enilu@localhost identified by '1234';
flush privileges;

grant select,update on testdb.* to enilu@localhost identified by '1234';
flush privileges;

DELETE FROM user WHERE User="enilu" and Host="localhost";
flush privileges;

update mysql.user set password=password('新密码') where User="enilu" and Host="localhost";