Mysql安装后可能会出现外部无法连接的问题,需要开放允许外部连

Mysql安装后可能会出现外部无法连接的问题,需要开放允许外部连接

mysql -u root  -p

mysql>use mysql

mysql>select user,host,plugin from user;

mysql>update user set host='%' where user='root' and host='127.0.0.1';

mysql>update user set host='%' where user='root' and host='localhost';

mysql>flush privileges;