SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Zealot
    Join Date
    Dec 2004
    Location
    Beside the historic creek in Kingston, London
    Posts
    128
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Can't connect to localhost

    On a new machine, I am trying to get MySql to work.

    IIS is up and going, but when I try to get MySql to work its magic it says, in reply to "mysql\bin" then "mysql" Error 2003: Can't connect to MySQL server on 'localhost' (10061).

    I've just bought Kevin Yank's gospel and I can't wait to get going ...

  2. #2
    SitePoint Wizard swdev's Avatar
    Join Date
    Oct 2004
    Location
    UK
    Posts
    1,053
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    That is probably because the MySQL server process has not been started.
    try typing net.exe start MySQL from a command prompt. That should display some messages indicating that the service is trying to start, and if it starts, then [b]mysql.exe -u root -p[b] should connect.

  3. #3
    SitePoint Zealot
    Join Date
    Dec 2004
    Location
    Beside the historic creek in Kingston, London
    Posts
    128
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks, swdev. That prompts this message

    'system error 5 has occurred. Access is denied.'

    Hopefully that reveals something positive...? (Most impressed by your skills, sw. Hope my problem won't seem too puny for you.)

  4. #4
    SitePoint Wizard swdev's Avatar
    Join Date
    Oct 2004
    Location
    UK
    Posts
    1,053
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Okay, thanks for the praise

    This may help

    start a command window
    goto your SQL installation directory, and then the bin sub-directory
    type mysqld.exe

    You should see some messages saying that MySQL is starting up, or some error messages.
    If all is well, you will not be returned to a command prompt.

    start a second command window
    goto your SQL installation directory, and then the bin sub-directory
    type mysqladmin.exe -u root -p shutdown
    This will shutdown the MySQL server

    then type mysql.exe --install-manual. This will install MySQL as a service that can then be started by net.exe start MySQL and stopped by net.exe stop MySQL

    If you want to name the service something else, say TestServer, then type mysqld.exe --install-manual TestServer.

    Hope this helps

  5. #5
    SitePoint Enthusiast
    Join Date
    Apr 2004
    Location
    The Netherlands
    Posts
    46
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    thanks, this thread partly helped my problem, I managed to start a second instance of Mysql this way, because the first instance crashed and I can't get it to shutdown, even a reboot won't help.
    When I try to start it, it says 'Service already exists' but there is no mysqld in my task manager. Any idea? Reinstalling doesn't quite work.


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
  •