解决方法简单多了。

First, you have to locate(in Terminal with "sudo find / -type s") where your mysql.sock file is located. In my case it was in /opt/lampp/var/mysql/mysql.sock Fire up Terminal and issue sudo Nautilus This starts your Files manager with super user privileges From Nautilus navigate to where your mysql.sock file is located Right click on the file and select Make Link Rename the Link File to mysqld.sock then Right click on the file and Cut it Go to /var/run and create a folder called mysqld and enter it Now right click and Paste the Link File Voila! You will now have a mysqld.sock file at /var/run/mysqld/mysqld.sock :)

我在CentOS VPS上也遇到了类似的问题。如果MySQL启动后无法启动或一直崩溃，请尝试以下步骤:

1)找到my.cnf文件(我的文件位于/etc/my.cnf)，并添加一行:

innodb_force_recovery = X

将X替换为从1到6的数字，从1开始，如果MySQL不启动，则递增。设置为4,5或6可以删除您的数据，所以要小心，并阅读http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html之前。

2)重启MySQL服务。只有SELECT将运行，这在此时是正常的。

3)用mysqldump逐个转储你所有的数据库/模式，不要压缩转储，因为以后你必须解压缩它们。

4)仅移动(或删除!)/var/lib/mysql中的bd目录，保留根目录中的单个文件。

5)停止MySQL，然后取消注释1)中添加的行。

6)恢复所有bd的倾倒在3)。

好运！

我遇到同样的错误，发现这是由于升级包，所以重新启动我的系统后，我解决了错误。

我认为由于sql库/包更新发生了错误，所以如果你正在进行一些升级，请尝试一下:)

这应该在终端中完成，在服务器内部，当你的mysql数据库没有正确安装，当你得到这个错误:'无法连接到本地mysql服务器通过套接字'/var/run/mysqld/mysqld。袜子(2)。

停止MySql

sudo /etc/init.d/mysqld stop

重新启动或启动它

sudo /etc/init.d/mysqld restart or sudo /etc/init.d/mysqld start

像这样做一个链接，然后把它交给系统

ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock

运行一个安全安装，它可以指导你配置mysql所需的所有过程

/usr/bin/mysql_secure_installation

解决方法简单多了。

First, you have to locate(in Terminal with "sudo find / -type s") where your mysql.sock file is located. In my case it was in /opt/lampp/var/mysql/mysql.sock Fire up Terminal and issue sudo Nautilus This starts your Files manager with super user privileges From Nautilus navigate to where your mysql.sock file is located Right click on the file and select Make Link Rename the Link File to mysqld.sock then Right click on the file and Cut it Go to /var/run and create a folder called mysqld and enter it Now right click and Paste the Link File Voila! You will now have a mysqld.sock file at /var/run/mysqld/mysqld.sock :)

由于多次安装mysql而出现此错误。 执行如下命令:

ps -A|grep mysql

通过以下命令终止进程:

sudo pkill mysql

然后运行命令:

ps -A|grep mysqld

也可以通过运行:

sudo pkill mysqld

现在你已经完全设置好了，只需运行以下命令:

service mysql restart
mysql -u root -p

又有很好的工作mysql吗