Find the answer to your Linux question:
Results 1 to 5 of 5
When I try start mySQL i get the error Code: mysqlshow: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Does anyone know what the problem is? I am ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Mar 2005
    Location
    South Africa
    Posts
    88

    mySQL Error


    When I try start mySQL i get the error

    Code:
    mysqlshow: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    Does anyone know what the problem is?

    I am using SuSe 9.2

  2. #2
    Just Joined! forgottentq's Avatar
    Join Date
    Jun 2006
    Location
    Virginia at the moment.
    Posts
    46
    does /var/lib/mysql/mysql.sock exsist? and if so what are the permissions on it? I'd start there.

  3. #3
    Linux User Giles's Avatar
    Join Date
    May 2005
    Location
    Gloucestershire and Cambridge, UK
    Posts
    283
    I suffered from a similar error a while ago: it wasn't quite the same, but my solution may be useful for you, especially if you've only just installed MySQL.
    Basically, just run these commands:
    Code:
    su mysql
    mysql_install_db
    Of course, if you've already run the mysql_install_db script, this probably wont be any help.

    HTH
    Toodle-oo
    Giles
    "Our greatest fear is not that we are powerless. Our greatest fear is Microsoft"
    Registered linux user #391027

  4. #4
    Just Joined!
    Join Date
    Jun 2006
    Location
    (.)
    Posts
    69
    It seems that mySql process is already running in your server, check the process list and kill the mysql and then restart it.

    I think it should work !!!

  5. #5
    Just Joined!
    Join Date
    Mar 2005
    Location
    South Africa
    Posts
    88
    Thanks, that solved the problem

Posting Permissions

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