944,221 Members | Top Members by Rank

Ad:
  • PHP Discussion Thread
  • Marked Solved
  • Views: 22712
  • PHP RSS
Jun 27th, 2007
0

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

Expand Post »
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.
Similar Threads
Reputation Points: 10
Solved Threads: 0
Junior Poster in Training
dudegio is offline Offline
66 posts
since May 2007
Jun 28th, 2007
0

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

What's your connection string? (Be sure to replace the password with something like 'PASSWORD' if you don't want it shared.)
Reputation Points: 23
Solved Threads: 23
Posting Pro in Training
Puckdropper is offline Offline
494 posts
since Jul 2004
Jun 28th, 2007
0

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

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....
Reputation Points: 10
Solved Threads: 0
Junior Poster in Training
dudegio is offline Offline
66 posts
since May 2007
Jun 28th, 2007
0

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

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)?
Reputation Points: 23
Solved Threads: 23
Posting Pro in Training
Puckdropper is offline Offline
494 posts
since Jul 2004
Jun 29th, 2007
0

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

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.
Reputation Points: 10
Solved Threads: 0
Junior Poster in Training
dudegio is offline Offline
66 posts
since May 2007
Jun 29th, 2007
0

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

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.
Reputation Points: 23
Solved Threads: 23
Posting Pro in Training
Puckdropper is offline Offline
494 posts
since Jul 2004

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in PHP Forum Timeline: retrieving a single cell of data from a MySQL database
Next Thread in PHP Forum Timeline: Is there a conflict between Php 4.3.2 and Php4.2.3?





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC