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 ...
  1. 07-28-2006 #1
    nortis
    nortis is offline
    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
    Reply With Quote Reply With Quote
  2. 07-28-2006 #2
    forgottentq
    forgottentq is offline
    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.
    Reply With Quote Reply With Quote
  3. 07-28-2006 #3
    Giles
    Giles is offline
    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
    Reply With Quote Reply With Quote
  4. 08-10-2006 #4
    mitto
    mitto is offline
    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 !!!
    Reply With Quote Reply With Quote
  5. 08-11-2006 #5
    nortis
    nortis is offline
    Just Joined!
    Join Date
    Mar 2005
    Location
    South Africa
    Posts
    88
    Thanks, that solved the problem
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

...