解决方法:
1)E:\MySQL Server下的my-huge.ini修改(skip-name-resolve, max_connections默认值为100,增大其值)并另存为my.cnf,分别复制粘贴到E:\MySQL Server\data\mysql,E:\MySQL Server\data,E:\MySQL Server\etc下面
2)关闭重启mysql:
net stop mysql
net start mysql
3)关闭重启计算机:
参考资料:
my.cnf里面添加skip-name-resolv可以解决
是/etc/my.cf,创建一个就得了。相关参数优化see here:
http://www.databasejournal.com/features/mysql/article.php/10897_1402311_2
C:\mysql\data\my.cnf on Windows systems
if your os is Windows
its name is my.iniyou can find *.cnf files in support-files directory
copy it to /etc and rename it as my.cnf
if your os is Windows
its name is my.ini
有3个配置参数是最重要的,即key_buffer_size,query_cache_size,table_cache。
Lost connection to MySQL server during query 错误
造成这样的错误原因很多
个人经验认为先试一试这两个参数,大部分都是这个原因引起的:
bind-address = 127.0.0.1
skip-name-resolve
远程连接的时候,需要开启这个参数,其实就是socket server端绑定服务器localhost
这两个参数任意一个就行。