在豹子上安装mysql:“无法通过套接字连接到本地MySQL服务器" [英] Installing mysql on leopard: "Can't connect to local MySQL server through socket"

问题描述

我迁移到一台新计算机上，并使用迁移助手在我的文件之间复制(这似乎在数据库之间复制)，但是我不得不使用macports安装Mysql(而上次我是通过Dan Benjamin的指南从源代码编译的).由于某种原因，mysql间歇性地引发以下错误；

I migrated to a new machine and used migration assistant to copy across my files (which seemed to copy across the DBs) but I had to use macports to install Mysql (whereas last time I compiled from source via Dan Benjamin's guide). For some reason, mysql is intermittently throwing the following error;

无法通过套接字'/opt/local/var/run/mysql5/mysqld.sock'(2)连接到本地MySQL服务器

Can't connect to local MySQL server through socket '/opt/local/var/run/mysql5/mysqld.sock' (2)

无论我尝试什么，它都会这样做，其中包括在/opt/local/etc/mysql5/my.cnf中设置套接字.以前，我已经设法通过重新启动计算机来临时解决此问题，但是尽管grep mysql告诉我我似乎有一个pid，但现在它只是不想知道.

It does this no matter what I try, which has included setting the socket in /opt/local/etc/mysql5/my.cnf. Previously I've managed to temporarily fix this by restarting the machine, but right now it just doesn't want to know, despite grep mysql telling me I seem to have a pid;

  0    46     1   0   0:00.01 ??         0:00.01 /opt/local/bin/daemondo --label=mysql5 --start-cmd /opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper start ; --stop-cmd /opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper stop ; --restart-cmd /opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper restart ; --pid=none
  0    70     1   0   0:00.01 ??         0:00.01 /bin/sh /opt/local/lib/mysql5/bin/mysqld_safe --datadir=/opt/local/var/db/mysql5 --pid-file=/opt/local/var/db/mysql5/localhost.pid
 74   100    70   0   0:09.22 ??         1:02.68 /opt/local/libexec/mysqld --basedir=/opt/local --datadir=/opt/local/var/db/mysql5 --user=mysql --pid-file=/opt/local/var/db/mysql5/localhost.pid --socket=/tmp/mysql.sock
501 66217 65266   0   0:00.00 ttys001    0:00.00 grep mysql

我该如何解决?接下来我有什么步骤可以采取?我已经尝试了几个星期，并且已经阅读了所有相关的博客文章，所以我完全没有主意.

How do I fix this? Are there any steps I can take next? I've been trying for a few weeks now and I've read round all relevant blog posts, so I'm completely out of ideas.

推荐答案

这是事实之后的方法，但这是我所做的:

This is way after the fact, but here's what I did:

touch /opt/local/var/run/mysql5/mysqld.sock
vi /opt/local/etc/mysql5/my.cnf

将以下行添加到my.cnf:

[mysqld_safe]
socket = /opt/local/var/run/mysql5/mysqld.sock

[client]
socket = /opt/local/var/run/mysql5/mysqld.sock

这应该允许您连接.这对豹子和雪豹都有效.

This should allow you to connect. This worked for me on both Leopard and Snow Leopard.

这篇关于在豹子上安装mysql:“无法通过套接字连接到本地MySQL服务器"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！