in Search
     
Latest post 05-25-2007 1:07 PM by keithrull. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 05-23-2007 6:57 PM

    • keithrull
    • Top 10 Contributor
    • Joined on 08-08-2005
    • San Diego, CA
    • Posts 1,956
    • Points 39,255

    MySQL Socket Error

    I was trying to run MySQL on my Suse Linux box when I got this error. Anybody who knows what I should do to solve this error?

    myopensuse102:~ # mysql stop
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    myopensuse102:~ # mysql start
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

    I tried navigating to the folder but i can't seem to find the mysql.sock file.

    myopensuse102:~ # cd var/lib
    bash: cd: var/lib: No such file or directory
    myopensuse102:~ # cd /var
    myopensuse102:/var # cd lib
    myopensuse102:/var/lib # cd mysql
    myopensuse102:/var/lib/mysql # ls
    .protected  ib_logfile0  ibdata1  mysql_upgrade_info  mysqld.log.1.bz2  test
    .tmp        ib_logfile1  mysql    mysqld.log          mysqld.log.2.bz2
    myopensuse102:/var/lib/mysql

    Anybody who can give me guidance on this?

     

    devpinoy sig

    • Post Points: 20
  • 05-24-2007 5:48 PM In reply to

    • cruizer
    • Top 10 Contributor
    • Joined on 12-14-2005
    • Singapore
    • Posts 944
    • Points 22,590

    Re: MySQL Socket Error

    wait. the "mysql" you were running might be the mysql command line utility, not the service startup/shutdown script. please check. in some distros (dunno about SuSE) it's named "mysqld" with d meaning daemon (or server process)
    http://devpinoy.org/blogs/cruizer
    Naglalayong buksan at palayain ang kamalayan ng Pinoy .NET developer
    • Post Points: 20
  • 05-25-2007 1:07 PM In reply to

    • keithrull
    • Top 10 Contributor
    • Joined on 08-08-2005
    • San Diego, CA
    • Posts 1,956
    • Points 39,255

    Re: MySQL Socket Error

    Thanks cruizer. I'll try this tonight.

    This is the first time i'm going to work with PHP and Linux since 2002 and man its pretty hard for a Microsoftie to get back in to "the light".

    devpinoy sig

    • Post Points: 5
Page 1 of 1 (3 items)