SitePoint Sponsor

User Tag List

Results 1 to 7 of 7
  1. #1
    Add new title here.. john's Avatar
    Join Date
    Jul 1999
    Location
    Amsterdam, The Netherlands
    Posts
    259
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)
    Hi,

    I have been experimenting with MySql for the last couple of days. I managed to install it on a Unix machine, got it running en then messed up.

    At this very moment I'm unable to start the MySql server. I have searched for help on mysql.com but nothing worked. I was wondering if there's a way to un-install mysl so I can start from scratch.

    But I can also imagine that there are other ways to get it running again.

    FYI, this is what I get if I use the PS command:

    PID TT STAT TIME COMMAND
    1465 p0- I 0:00.00 (mysqld)
    29870 p0- I 0:00.00 (mysqld)
    28759 p9 Ss 0:00.00 (bash)
    28847 p9 R+ 0:00.00 (ps)
    946 con- I 0:00.00 (mysqld)

    Help is very much appreciated.

    Thanks,

  2. #2
    Dumb PHP codin' cat
    Join Date
    Aug 2000
    Location
    San Diego, CA
    Posts
    5,460
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Looks to me like the mysql server is already running, if this is a new install just type:

    $> mysql -u root


    at the command prompt.
    Please don't PM me with questions.
    Use the forums, that is what they are here for.

  3. #3
    Add new title here.. john's Avatar
    Join Date
    Jul 1999
    Location
    Amsterdam, The Netherlands
    Posts
    259
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)
    This is what I get after typing mysql -u root

    ERROR 2002: Can't connect to local MySQL server

    Any suggestions?

  4. #4
    Dumb PHP codin' cat
    Join Date
    Aug 2000
    Location
    San Diego, CA
    Posts
    5,460
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    $> mysql -h localhost -u root
    Please don't PM me with questions.
    Use the forums, that is what they are here for.

  5. #5
    Add new title here.. john's Avatar
    Join Date
    Jul 1999
    Location
    Amsterdam, The Netherlands
    Posts
    259
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)
    Same error:

    ERROR 2002: Can't connect to local MySQL server


  6. #6
    SitePoint Wizard
    Join Date
    Jul 1999
    Location
    Chicago
    Posts
    2,629
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Try this:
    In the PID column of ps, you'll see mysql's PIDs. You need to kill those (or kill -9 if it doesn't work initially) and then restart safe_mysqld (don't forget the & at the end to put it in the background).

    Then try freddydoesphp's suggestion.

  7. #7
    Add new title here.. john's Avatar
    Join Date
    Jul 1999
    Location
    Amsterdam, The Netherlands
    Posts
    259
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)
    Thanks. That did the job!


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
  •