Default value for max_user_connections on mysql 5.1?

ASTRAPI

Well-Known Member
Jul 8, 2008
321
0
66
Hello

What is the default value for max_user_connections on mysql 5.1?

How can i set it to unlimited?

Thank you
 

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
42
348
somewhere over the rainbow
cPanel Access Level
Root Administrator
You can check the default for any variable by running the following command in root SSH:

Code:
mysqladmin var | grep variablename
Replacing variablename with the name of the variable. For example, if you run this command:

Code:
[email protected] [/]# mysqladmin var | grep max_user
| max_user_connections                    | 0
0 here means unlimited. Of note, this only works if you have not already set the variable in /etc/my.cnf file. If you have, take out the variable or comment it out in /etc/my.cnf and restart MySQL to see the default for the variable.