1、临时修改生效,不需要重启数据库
show variables like "max_connections"; #显示最大连接数
show processlist; #显示当前连接数
set global max_connections=1000; #设置最大连接数1000
show variables like "max_connections"; #显示最大连接数
2、找到mysql安装目录下的my.ini,修改max_connections=1000,重启数据库就永久生效了
max_connections=1000
- establishment connections connection serverToo rejectedestablishment connections servertoo rejected establishing connection wordpress database successfully established connection server error successfully established connection establishing verification connection recommende established connection exception办法 establishing verification recommended connection verification connection establish服务器 connection_id connection establish状态 connect