MySQL Connections Help

[wideopen]

Hey guys I need a little help.

I keep getting this error.

User ****** has already more than 'max_user_connections' active connections

I am on a Dedicated Server, and am very new to this.

How do I check or set the Max connections that I have?

I am using WHM?? Is this something I have control of? I had to set everything else up ?

Thanks in advance.

Phil

[sagoshawn]

Greetings!

Try this...

Use mysql_connect() instead of mysql_pconnect() unless you have a good reason. In particular, check this setting in third-party scripts (such as osCommerce).

Next, the file /etc/my.cnf typically holds defaults for mysql. Note: You will need to login in the shell as root to make the changes. A line of

[mysqld]
set-variable=max_connections=500

will increase the number of connections allowed to 500. you can change this to your needs. Please note that the instruction should be placed in the [mysqld] section. Otherwise MySQL will ignore it.

After resetting this, restart mysql (you would run "service mysqld restart" as root or issue the MySQL restart via WHM).

Hope this helps.

[wideopen]

Sounds great...Problem is you lost me at "try this"

Sorry but I'm a newbie at this, go ahead throw the stones, but I don't understand what you just said.

[sagoshawn]

I mean absolutely no offense by this. But... You might want to check with your dedicated server provider to see if they offer any management packages. You can pay for the server management and get things rolling, and learn from the tech along the way. I feel ok saying this to you because I am not a technician. So I undersatnd your situation, and server management is your best solution.

Hope this helps.

[wideopen]

No offence taken, But isn't that the purpose of boards such as this? So a person can learn?

[sagoshawn]

I think you might be better servered starting here: http://mysql.com/ A more direct avenue to a solution.

[rwh]

Login to ssh via root edit the file in etc folder

/etc/my.cnf

After making the change save and restart mysql

Joey