User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 391,555 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,635 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our PHP advertiser: Lunarpages PHP Web Hosting
Views: 4589 | Replies: 5 | Solved
Reply
Join Date: May 2007
Posts: 55
Reputation: dudegio is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 0
dudegio dudegio is offline Offline
Junior Poster in Training

Solution Can't connect to MySQL server on 'localhost' (10061)

  #1  
Jun 27th, 2007
Hello everyone!

I have problem with the configuration of MySQL.
I am using IIS, Php 4.3.11(CGI) and SQL Yog. All are working.
I also installed and used MySQL Servers and Clients 4.0.15 for my database. If i connect to the database, i encounter this error: Can't connect to MySQL server on 'localhost' (10061). I have reboot the PC so many times but same error occur. I have search and read manuals in the net but i cant find solution. Anyone knows how to solve this problem pls help. Im getting mad on this. I truly appreciate any help. thanks in advance.
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Jul 2004
Location: North East Indiana
Posts: 491
Reputation: Puckdropper is an unknown quantity at this point 
Rep Power: 5
Solved Threads: 20
Puckdropper Puckdropper is offline Offline
Posting Pro in Training

Re: Can't connect to MySQL server on 'localhost' (10061)

  #2  
Jun 27th, 2007
What's your connection string? (Be sure to replace the password with something like 'PASSWORD' if you don't want it shared.)
www.uncreativelabs.net

Old computers are getting to be a lost art. Here at Uncreative Labs, we still enjoy using the old computers. Sometimes we want to see how far a particular system can go, other times we use a stock system to remind ourselves of what we once had.
Reply With Quote  
Join Date: May 2007
Posts: 55
Reputation: dudegio is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 0
dudegio dudegio is offline Offline
Junior Poster in Training

Re: Can't connect to MySQL server on 'localhost' (10061)

  #3  
Jun 28th, 2007
Im not sure but it has nothing to do with the connection string.

The MySQL Server service cannot be started. I have used the SQLyog to connect but same error appear. I tried to start in MSDOS, still it fails and do the same in the bin directory the winmysqladmin but it fails to start as well. pls help....
Reply With Quote  
Join Date: Jul 2004
Location: North East Indiana
Posts: 491
Reputation: Puckdropper is an unknown quantity at this point 
Rep Power: 5
Solved Threads: 20
Puckdropper Puckdropper is offline Offline
Posting Pro in Training

Re: Can't connect to MySQL server on 'localhost' (10061)

  #4  
Jun 28th, 2007
Ok, we'll switch to software troubleshooting:
Is MySQL running and in memory? It should show up on Window's Processes list.

If not, perhaps something's preventing it from starting. Try launching it from a command prompt (not the run box, we want a chance to catch messages.)

Are you running other software that could interfere? MySQL probably wants to be on a specific port, and another program could be using it. What about Window's Firewall?

PHP does know about MySQL, right? The line extension=mysql.dll is uncommented in php.ini (for version 5)?
www.uncreativelabs.net

Old computers are getting to be a lost art. Here at Uncreative Labs, we still enjoy using the old computers. Sometimes we want to see how far a particular system can go, other times we use a stock system to remind ourselves of what we once had.
Reply With Quote  
Join Date: May 2007
Posts: 55
Reputation: dudegio is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 0
dudegio dudegio is offline Offline
Junior Poster in Training

Re: Can't connect to MySQL server on 'localhost' (10061)

  #5  
Jun 28th, 2007
Thanks for help. I got a solution on it. I deleted all related mysql data in prefetch and windows directory and install a fresh copy of mysql and it works. thanks for help. i truly appreciate it.

Im not sure of the cause of the automaic stoppage of mysql when i attempt to start the mysql service. Probably there were conflicts on versions for the fact that i have installed and uninstalled different versions of mysql.

If you have knowledge about the automatic stoppage or failure to start the mysql service please share. That could help me and anyone visited the site when we get paranoid of whats going on with mysql service. hehehe... Thank you very much.
Reply With Quote  
Join Date: Jul 2004
Location: North East Indiana
Posts: 491
Reputation: Puckdropper is an unknown quantity at this point 
Rep Power: 5
Solved Threads: 20
Puckdropper Puckdropper is offline Offline
Posting Pro in Training

Re: Can't connect to MySQL server on 'localhost' (10061)

  #6  
Jun 29th, 2007
It's very possible that you had version conflicts. They don't always play nice together.

I had a problem with MySQL stopping after it started a week ago that I fixed by rebooting. Maybe it's just something in the air.
www.uncreativelabs.net

Old computers are getting to be a lost art. Here at Uncreative Labs, we still enjoy using the old computers. Sometimes we want to see how far a particular system can go, other times we use a stock system to remind ourselves of what we once had.
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

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

 

DaniWeb PHP Marketplace
Thread Tools Display Modes

Similar Threads
Other Threads in the PHP Forum

All times are GMT -4. The time now is 9:41 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC