MySQL开启远程登录

对新建用户用户

CREATE USER 'username'@'%' IDENTIFIED BY 'password';

更改权限

grant all privileges on *.* to 'username'@'%' WITH GRANT OPTION;

刷新权限

flush privileges;

查看表

select host,user from user;