MySQL用户和权限

进行授权

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '!QAZ2wsx' WITH GRANT OPTION;

添加具有本地(localhost/127.0.0.1)访问权限的用户

create user 'newuser'@'localhost' identified by 'password';

创建具有远程访问权限的用户

create user 'newuser'@'%' identified by 'password';

修改密码
ALTER USER 'root'@'%' IDENTIFIED BY '!QAZ2wsx'

最好都必须加上，使权限生效

FLUSH PRIVILEGES;