mysql max_connections limit reset Last week I updated mysql max_connections to 1000 from 151 using

use mysql;
set global max_connections = 1000;


Today there was a power outage at the hosting company and the servers shut down and were then restarted.  After restart, the max_connections variable was reset to 151.

Is this default behavior?  How can I prevent max_connections global from getting reset?  

Reference:

MySQL 5.7
Yes this is the default behavior. How ? The default value for max_connections is 151.

This is true for MySQL 5.7, MySQL 5.6, and MySQL 5.5

If /etc/my.cnf does not have max_connections, then 151 comes up as max_connections.

You can just run set global max_connections = 1000;. 

Your hosting company must put that entry in /etc/my.cnf for you 

[mysqld]
max_connections=1000


Otherwise, every restart of mysqld will reset max_connections to 151.

I have suggested this before


Jul 06, 2012 : How to resolve too many connections and fatal error in mysql running on vps