Default value for max_user_connections on mysql 5.1?

A

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

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.
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
G Importing settings for PMA, Missing data for Default transformations for TextLink Databases 11
P STRICT MODE MySQL not disabled by default Databases 1
S mysql crash! TIMESTAMP with implicit DEFAULT value is deprecated. Databases 6
A Cannot update column, the value goes back to default Databases 1
K Foreign keys/default values/load data infile Databases 2
Similar threads
Importing settings for PMA, Missing data for Default transformations for TextLink
STRICT MODE MySQL not disabled by default
mysql crash! TIMESTAMP with implicit DEFAULT value is deprecated.
Cannot update column, the value goes back to default
Foreign keys/default values/load data infile
Top Bottom