MySQL Error

Discussion in 'Server Operation' started by DazzyB, Aug 10, 2007.

  1. DazzyB

    DazzyB New Member

    I'm having issues with MySQL... I have installed Ubuntu Dapper LAMP Server and after installation MySQL works, then I setup my Hosts file and networking etc... and after I restart I get this:

    Code:
    root@mail:~# mysql
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
    root@mail:~#
    
    I have re-installed 3 times already, and been up and down google and I have yet to find an answer, can anyone help?
     
  2. falko

    falko Super Moderator Howtoforge Staff

    What's the output of
    Code:
    netstat -tap
    and
    Code:
    ps aux | grep mysql
    ?
    What's in /etc/mysql/my.cnf?
     
  3. DazzyB

    DazzyB New Member

    netstat -tap:

    ps aux | grep mysql:

    /etc/mysql/my.cnf:

     
  4. falko

    falko Super Moderator Howtoforge Staff

    Looks ok. Can you connect using
    Code:
    mysql -u root -p
    ?
     
  5. DazzyB

    DazzyB New Member

    Well it askes for a password, but the mysql client is trying to connect via /tmp/mysql.sock

    and the sock file is in /var/run/mysqld/mysql.sock

    so I set that in webmin, and it works... in webmin that is, but thats all I need, its also fine on port 3306, so alls good.

     

Share This Page