用XAMPP裝裝好mysql之后，mysql -uroot 連不上，報這個錯誤：

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'?

在mysql的配置文件里，/opt/lampp/etc/my.cnf， 發(fā)現(xiàn)了這樣的配置：

?

    
      # The following options will be passed to all MySQL clients

[client]

#password       = your_password

port            = 3306

socket          = /opt/lampp/var/mysql/mysql.sock



# Here follows entries for some specific programs



# The MySQL server

[mysqld]

user            = nobody

port            = 3306

socket          = /opt/lampp/var/mysql/mysql.sock




    
  

原來mysql用的套接字文件是： /opt/lampp/var/mysql/mysql.sock 于是建立了個軟連接， 命令如下。不能建立硬鏈接，不知道為什么。

?

ln -s?/opt/lampp/var/mysql/mysql.sock ?/var/run/mysqld/mysqld.sock

現(xiàn)在可以用mysql -uroot命令登陸上了~

?

?

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'