SQL ERROR -'max_user_connections'

[desibreaker]

hello wj, i'm having a problem with my vps server, i'm getting this error

it has a phpbb board installed on the vps and a wordpress blog, what can be done to solve this issue

 

[BlaZe]

Login to SSH.

Edit /etc/my.cnf file and change the max_user_connections to 1500 or maybe more.

 

[l0calh0st]

Disable persistent connections in phpBB admincp >_>

 

[desibreaker]

hey blaze how do i edit the /etc/my.cnf

 

[AlternativeWeb]

Login to SSH.

Edit /etc/my.cnf file and change the max_user_connections to 1500 or maybe more.

hey blaze how do i edit the /etc/my.cnf

Like what Blaze said, login to your SSH account
then type something like:

nano /etc/my.cnf

depending on your editor.

If you don't know how to do this, just ask your host to do it for you.

 

[NewEraCracker]

Login to SSH.

Edit /etc/my.cnf file and change the max_user_connections to 1500 or maybe more.

1203 is an SQL error code :P

Information about this error:
http://dev.mysql.com/doc/refman/5.1/en/too-many-connections.html

hey blaze how do i edit the /etc/my.cnf

You can use Filezilla secure ftp, download my.cnf, edit it with Notepad++, save and then re-upload it.

May I know your MySQL version and which control panel are you using?

 

[RazorFX]

Login to SSH.

Edit /etc/my.cnf file and change the max_user_connections to 1500 or maybe more.

That would be too high IMO, raising it to 700 - 800 would do good.

 

[EnCiPh3r]

That would be too high IMO, raising it to 700 - 800 would do good.

Doesnt Matter its his own VPS

 

[Tango]

Login to SSH.

Edit /etc/my.cnf file and change the max_user_connections to 1500 or maybe more.

Thats a bad idea, if someone floods the forum the server can lock and the DB crash.

Find how many connections you are using at peak times and add 200 onto it in my.cnf.

This script is good for getting mysql info tuning-primer.sh