MySQL中的权限详解

grant select,insert,update,delete,create,drop privileges on database.* to user@localhost identified by 'passwd';

grant all privileges on database.* to user@localhost identified by 'passwd';

flush privileges;

show grants;

revoke delete on *.* from 'jack'@'localhost';

drop user 'jack'@'localhost';

rename user 'jack'@'%' to 'jim'@'%';

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123456');

drop database test;

select * from a into outfile "~/abc.sql"