Mysql创建远程连接

grant all privileges  on *.* to root@'%' identified by "root";

windows开启和关闭mysql

net start mysql

net stop mysql

最大允许数据包的容量是1M ,需要修改更大一点。20M

SHOW VARIABLES LIKE '%max_allowed_packet%';

set global max_allowed_packet = 2*1024*1024*10; 

SHOW VARIABLES LIKE '%interactive_timeout%';

set global interactive_timeout = 2*1024*1024*10;