mysql用户和授权

查看权限
show grants for "test"@"localhost"
添加用户
create user "test"@"localhost" IDENTIFIED by "root";
修改密码
set PASSWORD for "test"@"localhost"=PASSWORD("test");
授权
GRANT ALL ON *.* TO 'test'@'localhost'