增加用户
CREATE USER ‘dog’@’%’ IDENTIFIED BY ‘123456’;
%表示允许通过所有的途径登录服务器。
修改密码
SET PASSWORD FOR ‘username’@’host’ = PASSWORD(‘newpassword’);
授权
GRANT ALL ON . TO ‘pig’@’%’;
GRANT SELECT, INSERT ON test.user TO ‘pig’@’%’;
查看所有用户
SELECT DISTINCT CONCAT(‘User: ”’,user,”’@”’,host,”’;’) AS query FROM mysql.user