MySql expert needed

[OxDomains]

Ok here is the problem:
I constantly get "too many connections" error,
when i log into any domain cpanel and go to MySql/PhpMyAdmin, it says something like:Wrong username/password. Access denied.

I need someone to fix this... i am totally lost on this-

Please only respond if you know how to fix this-

I will only pay via PayPal :p

please pm me on this board or any the contact options located on my profile

Thanks

 

[PolurNET]

Request filled

 

[OxDomains]

Issue still not resolved- assistance still required

 

[yz0rx]

Having problems trying to connect with phpmyadmin only? Try using Navicat 2004. Definetly a helpful tool if you're constantly modifying your databases. Has some cool features.

 

[YUPAPA]

The connection error happens when connecting with phpmyadmin? :?

 

[PolurNET]

I would look through the php files itself Richie... there may be a leak or a mysql bug that isn't being noticed...

 

[cerebus]

Reason is probably that you have a set of scripts opening persistant connections to the database. Possible ways of solving it:
1.) Use non-persistant connections in the scripts
2.) Lower timeout-setting for persistent connections
3.) Raise max_connections setting

 

[armstrong]

Welcome back, cerebus!

 

[cerebus]

Thanks a bunch Armstrong. Didn't think anyone would remember me

And for my answer. If you just set the maximum_connections alot higher, do it gradually as you dont want to overload the machine.

 

[redhippo]

welcom home

yea...welcome back man from sweden...!


http://www.namepros.com/showthread.php?p=368842#post368842

 

[OxDomains]

Thanks for the advice everyone - i looked and looked and still cant figure this puppy out!
Anyone intrested in making cash....

 

[cerebus]

PM sent.