max_user_connection problem

[seachen]

1 of my user website show this problem. other website working fine.

may i know how to solve this problem?

 

[Dravu]

1 of my user website show this problem. other website working fine.

may i know how to solve this problem?

Do you have this file?:
/etc/my.cnf

If you do, find the the setting "max_user_connections" and raise the number. If not, MySQL comes with some pre-defined templates for the my.cnf file that you can edit and use.

 

[seachen]

Do you have this file?:
/etc/my.cnf

If you do, find the the setting "max_user_connections" and raise the number. If not, MySQL comes with some pre-defined templates for the my.cnf file that you can edit and use.

i not found it in "Directadmin - File Editor". may i know how to add in ?

 

[Dravu]

i not found it in "Directadmin - File Editor". may i know how to add in ?

You'll have to log into shell and check/edit it.

 

[seachen]

You'll have to log into shell and check/edit it.

ya. i have the server root acccess.

may i know how do i edit it?

 

[Dravu]

ya. i have the server root acccess.

may i know how do i edit it?

nano -w /etc/my.cnf

That'll open up the editor or create a new file if you don't have one. If it's there, just find the max_user_connections option and change it to a higher value. If it says it's creating a new file, then just put the option in there like this:

max_user_connections = ###

of course, replacing "###" with the number of your choosing.

Once you're done with the changes, do Ctrl + X and it'll ask if you want to save. Tell it yes and then restart MySQL.