SQL ERROR -'max_user_connections'

[desibreaker]

hello KWWH, 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

desibreaker Reviewed by desibreaker on 8th Jan 2012. SQL ERROR -'max_user_connections' hello KWWH, i'm having a problem with my vps server, i'm getting this error http://www.besthostingforums.com/images/cdn/besthostingforums.com/2012/01/0VPwz-1.png it has a phpbb board installed on the vps and a wordpress blog, what can be done to solve this issue Rating: 5

[BlaZe]

Login to SSH.

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

[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

Information about this error:
http://dev.mysql.com/doc/refman/5.1/...nnections.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

[Gavo]

This site is using a hacked database of W junction

[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.