Can't connect on localhost even though it is listening

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • dlite922
    Recognized Expert Top Contributor
    • Dec 2007
    • 1586
    #1

    Can't connect on localhost even though it is listening

    I've verified 7 ways from Sunday that mysql service is running and listening on port 3306.

    I have ActivePorts, which is a live monitor of connections on your windows machine. Mysql and mysql-nt are listening on their default ports.

    I'm not sure what I did over the past few month since I have not connected to the command line, but I can't seem to connect.

    I installed drupal and was able to install (create DB) during which time I was not able to command-line in.

    I uninstalled mysql and reinstalled on a completely different hard drive/directory. Same issue.

    I've googled all I could but my problem is unique but error message is not.

    So when you see this error:
    ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)


    You do the following steps:

    1. Check MySQL service is running.......C HECK!
    2. Check that it's listening on some port ....3306 CHECK!
    3. Try to telnet on that port.....OOPS!

    Can't telnet. Don't know why? I'm out of ideas guys. MySQL is started and listening on port 3306, why can't I connect to it?

    Thanks for any help,




    Dan
    Tags: None
    • acoolguy
      New Member
      • Jul 2010
      • 13
      #2
      You got a firewall it could be that stopping it?

        Comment

        • dlite922
          Recognized Expert Top Contributor
          • Dec 2007
          • 1586
          #3
          Nope, no firewall.

          I did forget to mention that The MySQL Configuration Utility always froze on the last step, "Applying Security Settings" and had to kill the process, but anyway...

          UPDATE:
          This problem went away. Not sure what I did or what caused it to act up, but here's a list of events actions after OP.

          1. Ran the config tool again, this time opt to not do networking and changed the port to 3333.

          2. Again it froze on the last step, "Apply Config Setting" and I killed it.

          3. Confirmed MySQL was running and listening on the new port 3333.

          4. Attempted to log in on that port and got an Access Denied message this time.

          5. Rebooted the PC and I got a weird message saying I don't have permission to do this, I thought i was hacked at this point seeing remote connections on a series of consecutive ports, so I unplugged the PC and rebooted.

          6. It froze after it had rebooted and wanted to go into stand by (i.e. got the frozen message "Preparing to go into stand by...") even though my computer is not configured to go into stand by or hibernation. It's always on and the OS has always been stable.

          7. Rebooted once again and everything started working fine. I was able to log in that gave me an Access denied message before.

          8. Changed the port back to 3306 and continued to work.

          It's working now and I don't have much time to spend on it since I'm getting a new server anyway.

          I'm not sure if the above is any helpful for anybody, but that's what happened to me.

          Cheers,


          Dan

            Comment

            Previous template Next
            Working...