mysql增加用户与权限修改

增加用户

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