How to Fix MyBB SQL Error

[V0RT3X]

Well I get a Error on my Site every Hour or so, it says:
"MySQL Error: To Many Connectiosn"

Do I need to upgrade to a new host or what?

 

[fords8]

http://dev.mysql.com/doc/refman/5.0/en/ ... tions.html

Check with your host. It could be a DDoS attack or they need to increase the max_connections value.

 

[Nebulous]

A lot of times you just need to wait a little bit and it'll go away. However if its happening all the time, then you'll need a better hosting package or switch to a new host.

 

[Vernard]

What type of hosting do you have? (Shared,VPS,Dedi)

If you are on shared hosting then you can try optimizing your site. Otherwise you will likely have to upgrade to a VPS or Dedi.

 

[Aki-P]

It seems like too many concurrent users accessing the Database at the same time. The highest allowed connection is usually around 30 per Database account, but stingier hosts will give you 10-20.

So yes, you either need to shop around for a host that allows for more on Shared hosting, or upgrade to VPS hosting where it's essentially unlimited.

There was a MyBB config code out there which you can use to link multiple database accounts on the Database. Because the 10, 20, or 30 limit is per account. The code basically just assigns a random DB account to each visitor, so the odds of 1 account hitting the limit are much lower.

If you plan to try that, be careful. It could violate the host's TOS. You should be able to dig that up on MyBB's support forums.

 

[emmiehunk]

first of all you should go to Mysql server instance config wizard and then you have to remove it using add/remove software in control panel and then uninstall it.After you have uninstalled the wizard,you must manually delete the folder where it was.after all the steps you can again install and hopefully the error will not appear now.