SitePoint Sponsor

User Tag List

Results 1 to 7 of 7
  1. #1
    Addicted to the Source of Life PowerBit's Avatar
    Join Date
    Feb 2004
    Location
    Loveland Co
    Posts
    548
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    I have performed the following (as stated in the MySQL manual):


    1) I have been shutting down the service of the server from the control panel before I start.
    2.) Then in one terminal I change directories to point to the correct bin directory.
    3.) I restart in that terminal from the bin directory in the 'mysqld-nt --skip-grant-tables' mode.
    4.) Open new window.
    5.) Change to bin directory.
    6.) Then I type in 'mysqladmin -u root
    flush-privileges password "newpwd"' -- replacing with my password.
    7.) Hit return.

    Now I have done all that and still recieve this error: 'Can't connect to MySQL server on 'localhost' (10061)'

    *When I set up the server I did check to see if I would get the "Localhost" homepage and did, when I initially installed the software.

    Can anyone step me through this process and get me beyond this error message?

    --Billy

  2. #2
    SitePoint Columnist
    Join Date
    Nov 2003
    Location
    Ohio
    Posts
    411
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hey onebit - Blane here again - take a look through this link...especially the various reasons for the errror and also some of the user comments.

    http://dev.mysql.com/doc/mysql/en/ca...to-server.html
    Freelance System Administrator, Researcher, Writer
    Practical Applications
    Open Sourcery "SitePoint's Open Source Blog"

  3. #3
    Addicted to the Source of Life PowerBit's Avatar
    Join Date
    Feb 2004
    Location
    Loveland Co
    Posts
    548
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Red face Need help understanding this approach!

    Hi Blane, good to hear from you!

    The following is the only chatter on Windows XP in that whole page:

    If the server is running on Windows NT, 2000, XP, or 2003 and is started with the --enable-named-pipe option, you can also connect with named pipes if you run the client on the host where the server is running. The name of the named pipe is MySQL by default. If you don't give a hostname when connecting to mysqld, a MySQL client first tries to connect to the named pipe. If that doesn't work, it connects to the TCP/IP port. You can force the use of named pipes on Windows by using . as the hostname.

    1st. does this look like a possible approach?

    2nd. Could you help me define some terms?
    What is the client?
    What is a pipe?

    3rd. This reference talks about connecting to mysqld and not mysqld- nt; can we still use this method to connect to mysqld- nt; are we even facing the issue of connecting to mysqld- nt at this point?

    To my understanding the connection to mysqld-nt has already been made. Is there a way to check if it is running or is the connection with local host error showing us that it is not connecting?

    Thank you Blane

    Further more we could switch to IM if you wanna chat that way or we can stay here for the documentation for others.

    In the mean time I am going to be looking around through out the refereneces you gave me.

    -- Billy

  4. #4
    Addicted to the Source of Life PowerBit's Avatar
    Join Date
    Feb 2004
    Location
    Loveland Co
    Posts
    548
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    These questions are open to anyone who has answers...

    Thank you for your support!

  5. #5
    Addicted to the Source of Life PowerBit's Avatar
    Join Date
    Feb 2004
    Location
    Loveland Co
    Posts
    548
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    If you need additional information let me know!

    Thanks Billy

  6. #6
    Addicted to the Source of Life PowerBit's Avatar
    Join Date
    Feb 2004
    Location
    Loveland Co
    Posts
    548
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Trying to keep this thread alive... I still need assistance by anyone that has some time and knowledge to share.

    You are greatly appreciated,

    Billy

  7. #7
    SitePoint Columnist
    Join Date
    Nov 2003
    Location
    Ohio
    Posts
    411
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Have you tried dumping everything and starting from scratch? Complete resintall of MySQL client and server?
    Freelance System Administrator, Researcher, Writer
    Practical Applications
    Open Sourcery "SitePoint's Open Source Blog"


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •