Default value for max_user_connections on mysql 5.1?

This should be helpful I think:
MySQL :: MySQL 5.0 Reference Manual :: 5.5.4 Setting Account Resource Limits

 

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:

root@host [/]# 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.