MySql expert needed

OxDomains · 11-20-2004, 06:55 AM

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

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

Thanks

PolurNET · 11-20-2004, 09:40 AM

Request filled

OxDomains · 11-21-2004, 04:57 AM

Issue still not resolved- assistance still required

yz0rx · 11-21-2004, 05:38 AM

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 · 11-21-2004, 08:47 AM

The connection error happens when connecting with phpmyadmin?

PolurNET · 11-21-2004, 08:59 AM

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

cerebus · 11-21-2004, 09:34 AM

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 · 11-21-2004, 09:48 AM

Welcome back, cerebus!

cerebus · 11-21-2004, 10:13 AM

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 · 11-21-2004, 12:48 PM

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

http://www.namepros.com/showthread.p...842#post368842

OxDomains · 11-24-2004, 03:23 AM

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

cerebus · 11-24-2004, 10:47 AM

PM sent.

11-20-2004, 06:55 AM	#1 (permalink)
OxDomains Senior Member Join Date: Sep 2003 Location: NYC Posts: 2,512 94.31 NP$ (Donate)	MySql expert needed 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 please pm me on this board or any the contact options located on my profile Thanks __________________ FHAMortgage.us.com is for Sale

11-20-2004, 09:40 AM	#2 (permalink)
PolurNET ₪NamePros Elite™ Join Date: Jul 2004 Location: Kingston, Canada Posts: 2,963 365.30 NP$ (Donate)	Request filled __________________ •• PolurNET Communications •• Avoid the Freeze, Enjoy the Breeze! = *A very* special day, February 12th = Proudly #1 on NamePros and WebHostingJury for over 3 years! \|\|LawPoint.org •• GREAT UK HOSTING DEALS NOW AT: ExcellentHost.com** ••

11-21-2004, 04:57 AM	#3 (permalink)
OxDomains Senior Member Join Date: Sep 2003 Location: NYC Posts: 2,512 94.31 NP$ (Donate)	Issue still not resolved- assistance still required __________________ FHAMortgage.us.com is for Sale

11-21-2004, 05:38 AM	#4 (permalink)
yz0rx NamePros Member Join Date: Oct 2004 Posts: 96 160.00 NP$ (Donate)	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. __________________ Firefox Users: My IP Tool

11-21-2004, 08:47 AM	#5 (permalink)
YUPAPA NamePros Member Join Date: Sep 2004 Posts: 132 24.20 NP$ (Donate)	The connection error happens when connecting with phpmyadmin? __________________ $i->ghost( :ghost: )

11-21-2004, 08:59 AM	#6 (permalink)
PolurNET ₪NamePros Elite™ Join Date: Jul 2004 Location: Kingston, Canada Posts: 2,963 365.30 NP$ (Donate)	I would look through the php files itself Richie... there may be a leak or a mysql bug that isn't being noticed... __________________ •• PolurNET Communications •• Avoid the Freeze, Enjoy the Breeze! = *A very* special day, February 12th = Proudly #1 on NamePros and WebHostingJury for over 3 years! \|\|LawPoint.org •• GREAT UK HOSTING DEALS NOW AT: ExcellentHost.com** ••

11-21-2004, 09:34 AM	#7 (permalink)
cerebus NamePros Regular Join Date: Oct 2003 Location: Sweden Posts: 395 655.10 NP$ (Donate)	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

11-21-2004, 09:48 AM	#8 (permalink)
armstrong Man from Manila Join Date: Jul 2003 Location: The Net Posts: 6,840 701.50 NP$ (Donate)	Welcome back, cerebus! __________________ Apollo's excellent 3-letter .BIZ auction; $1 starting bid!

11-21-2004, 10:13 AM	#9 (permalink)
cerebus NamePros Regular Join Date: Oct 2003 Location: Sweden Posts: 395 655.10 NP$ (Donate)	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.

11-21-2004, 12:48 PM	#10 (permalink)
redhippo NamePros Expert Join Date: Oct 2003 Location: ANForum Posts: 5,244 3,630.35 NP$ (Donate)	welcom home yea...welcome back man from sweden...! http://www.namepros.com/showthread.p...842#post368842 __________________ \|www.vb-skins.com\|- Quality Premade Vbulletin skins for Your VB forum makeover \|www.Banjir.com\|-Free image hosting?[B]For Sale!\|AlphaScripts\|Money Generating Scripts FREE VB Skins

11-24-2004, 03:23 AM	#11 (permalink)
OxDomains Senior Member Join Date: Sep 2003 Location: NYC Posts: 2,512 94.31 NP$ (Donate)	Thanks for the advice everyone - i looked and looked and still cant figure this puppy out! Anyone intrested in making cash.... __________________ FHAMortgage.us.com is for Sale

11-24-2004, 10:47 AM	#12 (permalink)
cerebus NamePros Regular Join Date: Oct 2003 Location: Sweden Posts: 395 655.10 NP$ (Donate)	PM sent.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)