Increase connections to MySQL

[Wanch]

I'm getting this error from MySQL:

Too many connections

How do I increase the connection limit via console or WHM?

[v0id]

In MySQL version 3.x and 4.x you shall open the file called "/etc/my.cnf", and edit the variable/line saying something like "max_connections". The exact line is different from version to version, but see if you can find it.

[Wanch]

Thanks, I added the line and restarted the service. Haven't gotten the error yet.

[Jordan]

v0id is correct. By default it only allows 100 connections. Edit your /etc/my.cnf file and ADD:

[mysqld]
max_connections=500

Restart MySQL (in WHM) /etc/restartsrv_mysql OR execute SET GLOBAL max_connections = 500; in MySQL

More info: http://dev.mysql.com/doc/refman/5.0/...nnections.html

[Wanch]

Thanks.