MYSQL GRANT PRIVILEGES

//给root用户权限
GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY 'root'  WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY 'root'  WITH GRANT OPTION;

//给test用户授权pwd:test
GRANT select,update,insert,delete ON test.* TO test@"%" IDENTIFIED BY 'test'  WITH GRANT OPTION;

//去除drop动作的权限
REVOKE DROP ON `test`.* FROM 'test'@'%';
//添加drop动作权限
GRANT DROP ON `test`.* TO 'test'@'%';
//刷新系统权限列表
flush privileges;
//删除用户
drop user test@%;
//修改密码
update mysql.user set password=password('新密码') where User="test" and Host="%";
//显示表名
describe 表名;