blocks|key|140055|text|尝试启动MySQL服务器：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|140056|mysql.server+start|offset|length|style|CODE|140057|entityMap^0|0|0|I|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@$D|L|E|M|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

Try to start the MySQL server:

<code>mysql.server start</code>

blocks|key|140086|text|在更新OS+X+Yosemite后，我得到了同样的问题，好的，解决方案很简单，检查系统首选项->+mysql，状态是停止。只需重新启动它，它现在就可以在我的mac上正常工作了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|140087|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I got the same question after updating OS X Yosemite, well the solution is quite simple, check system preference -> mysql, the status was STOP. Just restart it and it works fine on my mac now.

blocks|key|140139|text|适用于MAMP|type|unstyled|depth|inlineStyleRanges|entityRanges|data|140140|ln+-s+/Applications/MAMP/tmp/mysql/mysql.sock+/tmp/mysql.sock|code-block|syntax|javascript|140141|来自https://coderwall.com/p/w5kwzw/solved-can-t-connect-to-local-mysql-server-through-socket-tmp-mysql-sock|offset|length|140142|更新:每次我的电脑重启时，我都要输入这个命令，所以我创建了一个快捷方式。|140143|在终端类型中执行以下操作：|140144|~:+vi+~/.profile|140145|添加|140146|alias+...='source+~/.profile'
alias+sockit='sudo+ln+-s+/Applications/MAMP/tmp/mysql/mysql.sock+/tmp/mysql.sock'|140147|保存。|140148|在终端类型中：|140149|用于源.profile配置的~:+...。|style|CODE|140150|现在在终端中，您只需输入|140151|~:+sockit|140152|entityMap|0|LINK|mutability|MUTABLE|url|https://coderwall.com/p/w5kwzw/solved-can-t-connect-to-local-mysql-server-through-socket-tmp-mysql-sock^0|0|0|2|2V|0|0|0|0|0|0|0|0|0|E|6|0|0|0^^$0|@$1|2|3|4|5|6|7|1E|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|1F|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|1G|8|@]|9|@$I|1H|J|1I|1|1J]]|A|$]]|$1|K|3|L|5|6|7|1K|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|1L|8|@]|9|@]|A|$]]|$1|O|3|P|5|D|7|1M|8|@]|9|@]|A|$E|F]]|$1|Q|3|R|5|6|7|1N|8|@]|9|@]|A|$]]|$1|S|3|T|5|D|7|1O|8|@]|9|@]|A|$E|F]]|$1|U|3|V|5|6|7|1P|8|@]|9|@]|A|$]]|$1|W|3|X|5|6|7|1Q|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|1R|8|@$I|1S|J|1T|10|11]]|9|@]|A|$]]|$1|12|3|13|5|6|7|1U|8|@]|9|@]|A|$]]|$1|14|3|15|5|D|7|1V|8|@]|9|@]|A|$E|F]]|$1|16|3|-4|5|6|7|1W|8|@]|9|@]|A|$]]]|17|$18|$5|19|1A|1B|A|$1C|1D]]]]

For MAMP

<pre><code>ln -s /Applications/MAMP/tmp/mysql/mysql.sock /tmp/mysql.sock
</code></pre>

From <a href="https://coderwall.com/p/w5kwzw/solved-can-t-connect-to-local-mysql-server-through-socket-tmp-mysql-sock" rel="noreferrer">https://coderwall.com/p/w5kwzw/solved-can-t-connect-to-local-mysql-server-through-socket-tmp-mysql-sock</a>

UPDATE:
Every time my computer restarts I have to enter this command, so I created a shortcut.

Do the following in terminal type:

<pre><code>~: vi ~/.profile
</code></pre>

Add

<pre><code>alias ...='source ~/.profile'
alias sockit='sudo ln -s /Applications/MAMP/tmp/mysql/mysql.sock /tmp/mysql.sock'
</code></pre>

Save.

In terminal type:

<code>~: ...</code> to source the .profile config.

Now in terminal you can just type

<pre><code>~: sockit
</code></pre>

blocks|key|140565|text|以下命令解决了我的问题：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|140566|sudo+chown+-R+_mysql:mysql+/usr/local/var/mysql

sudo+mysql.server+start|code-block|syntax|javascript|140567|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Following command resolved my issue: 

<pre><code>sudo chown -R _mysql:mysql /usr/local/var/mysql

sudo mysql.server start
</code></pre>

blocks|key|4647155|text|在尝试了所有解决方案后，它只在指定主机后对我有效|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4647156|mysql+-u+root+-p+-h127.0.0.1|code-block|syntax|javascript|4647157|当询问密码时|4647158|Enter+password:|4647159|按enter键|4647160|如果一切正常的话，它会工作的。|4647161|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

After trying all solutions it worked only for me after specifying the host 

<pre><code>mysql -u root -p -h127.0.0.1
</code></pre>

when asking for password 

<pre><code>Enter password:
</code></pre>

press enter 

and it will work , if everything is ok as above .

blocks|key|4647087|text|试试这个，它对我很有效。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4647088|sudo+/usr/local/mysql/support-files/mysql.server+start+|code-block|syntax|javascript|4647089|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Try this it worked for me.
<pre><code>sudo /usr/local/mysql/support-files/mysql.server start 
</code></pre>

blocks|key|4647197|text|在挣扎了几个小时之后，唯一起作用的就是|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4647198|sudo+mysql.server+start|code-block|syntax|javascript|4647199|然后使用以下命令进行安全安装|4647200|mysql_secure_installation+|4647201|然后通过以下方式连接到数据库|4647202|mysql+-uroot+-p|4647203|Mysql是通过homebrew安装的，版本是|4647204|Server+version:+5.7.21+Homebrew|4647205|指定版本可能会有所帮助，因为不同版本的解决方案可能会有所不同。|4647206|entityMap^0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Y|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|10|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|12|8|@]|9|@]|A|$]]|$1|Q|3|R|5|D|7|13|8|@]|9|@]|A|$E|F]]|$1|S|3|T|5|6|7|14|8|@]|9|@]|A|$]]|$1|U|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|V|$]]

After struggling for hours the only thing which worked was

<pre><code>sudo mysql.server start
</code></pre>

Then do a secure installation with

<pre><code>mysql_secure_installation 
</code></pre>

Then connect to the db via

<pre><code>mysql -uroot -p
</code></pre>

Mysql is installed via homebrew and the version is 

<pre><code>Server version: 5.7.21 Homebrew
</code></pre>

Specifying the version might be helpful as the solution may be different based upon the version.

blocks|key|4646652|text|在/etc/my.cnf中的mysql配置文件中，进行以下更改，然后重新启动mysqld守护进程|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4646653|[client]
socket=/var/lib/mysql/mysql.sock|code-block|syntax|javascript|4646654|也可以查看这个相关的帖子|4646655|Can't+connect+to+local+MySQL+server+through+socket+'/tmp/mysql.sock|4646656|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/16325607/cant-connect-to-local-mysql-server-through-socket-tmp-mysql-sock^0|1|B|12|6|0|0|0|0|1V|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@$9|X|A|Y|B|C]|$9|Z|A|10|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|11|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|12|8|@]|D|@]|E|$]]|$1|M|3|N|5|6|7|13|8|@]|D|@$9|14|A|15|1|16]]|E|$]]|$1|O|3|-4|5|6|7|17|8|@]|D|@]|E|$]]]|P|$Q|$5|R|S|T|E|$U|V]]]]

In your mysql config file, which is present in <code>/etc/my.cnf</code> make the below changes and then restart <code>mysqld</code> dameon process

<pre><code>[client]
socket=/var/lib/mysql/mysql.sock
</code></pre>

As well check this related thread

<a href="https://stackoverflow.com/questions/16325607/cant-connect-to-local-mysql-server-through-socket-tmp-mysql-sock">Can&#39;t connect to local MySQL server through socket &#39;/tmp/mysql.sock</a>

blocks|key|4646713|text|下面解决了我的问题：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4646714|检查您的MySQL服务器正在侦听的位置:+netstat+-nlp如果它正在侦听TCP，则在连接到数据库时使用127.0.0.1，而不是"localhost“|4646715|检查MySQL文档here|offset|length|4646716|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.1/en/can-not-connect-to-server.html^0|0|0|9|4|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@$F|S|G|T|1|U]]|A|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]]]

Following resolved my issue:

Check where is your MySQL server is listning to: netstat -nlp
If it is listning to TCP then use 127.0.0.1 while connecting to DB instead of "localhost"

Check MySQL doc <a href="http://dev.mysql.com/doc/refman/5.1/en/can-not-connect-to-server.html" rel="noreferrer">here</a>

blocks|key|4647343|text|首先键入这个-：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4647344|brew+services+start+mysql|code-block|syntax|javascript|4647345|然后这个-：|4647346|mysql+-uroot|4647347|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

First Type this-:

<pre><code>brew services start mysql
</code></pre>

Then this -:

<pre><code>mysql -uroot
</code></pre>

blocks|key|4647359|text|键入终端，如下所示：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4647360|mysql.server+start|code-block|syntax|javascript|4647361|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Type in the terminal as follows:

<pre><code>mysql.server start
</code></pre>

blocks|key|4647072|text|如果你在Mac中使用XAMPP，并且已经安装了带有Homebrew的MySQL，你可能会遇到这个问题。在XAMPP+manager窗口中，转到Manage+Servers并选择MySQL，然后单击configure并打开配置文件，在这里您有了套接字文件路径，将该路径放入您的MySQL主机配置中，它就应该可以工作了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4647073|大概是这样的：|4647074|...
[client]
#password+++=+your_password
port++++++++=+3306
socket++++++=+/Applications/XAMPP/xamppfiles/var/mysql/mysql.sock
...|code-block|syntax|javascript|4647075|然后，例如在Django中：|4647076|...++++
DATABASES+=+{
++++++++"default":+{
++++++++++++"ENGINE":+"django.db.backends.mysql",
++++++++++++"NAME":+"database_name",
++++++++++++"USER":+"user",
++++++++++++"PASSWORD":+"password",
++++++++++++"HOST":+"/Applications/XAMPP/xamppfiles/var/mysql/mysql.sock",
++++++++++++"PORT":+"",
++++++++}
++++}
...|4647077|希望这能有所帮助。|4647078|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|T|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|U|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

If you are using XAMPP in Mac OS X and have installed MySQL with Homebrew you may have this problem. In XAMPP manager window go to Manage Servers and select MySQL, then click configure and open the configuration file, there you have the socket file path, put the path in your MySQL host config and it should work.

It's something like this:

<pre><code>...
[client]
#password = your_password
port = 3306
socket = /Applications/XAMPP/xamppfiles/var/mysql/mysql.sock
...
</code></pre>

then, for instance in Django:

<pre><code>... 
DATABASES = {
 "default": {
 "ENGINE": "django.db.backends.mysql",
 "NAME": "database_name",
 "USER": "user",
 "PASSWORD": "password",
 "HOST": "/Applications/XAMPP/xamppfiles/var/mysql/mysql.sock",
 "PORT": "",
 }
 }
...
</code></pre>

Hope this helps.

blocks|key|4647282|text|首先，对我来说，知道数据目录在哪里是关键。/usr/local/var/mysql在这里，至少有一个扩展名为.err的文件前面有我的本地计算机名。它包含了我需要诊断的所有信息。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4647283|我想我搞砸了，我先安装了MySQL8。我的应用程序与它不兼容，所以我不得不降级回5.7|4647284|我的解决方案适用于/usr/local/etc/my.cnf|4647285|找到这行，如果它在那里。我认为这与MySQL8有关：|4647286|mysqlx-bind-address+=+127.0.0.1+|code-block|syntax|javascript|4647287|删除它，因为在MySQL5.7中，它不喜欢错误日志中的它|4647288|如果绑定地址下没有这一行，也要添加这一行。|4647289|socket=/tmp/mysql.sock|4647290|转到/tmp目录并删除其中的所有mysql.sock文件。在服务器启动时，它将重新创建sock文件|4647291|丢弃mySQL处于停止状态的数据目录。我的是/usr/local/var/mysql。这与日志所在的位置相同|4647292|我从那里开始奔跑|4647293|>mysqld+--initialize|4647294|然后一切启动working...this命令会给你一个随机的密码结束。保存该密码供下一步使用|4647295|运行此命令来分配我自己的密码。|4647296|>mysql_secure_installation+|4647297|两者都有|4647298|>brew+services+stop+mysql@5.7|4647299|和|4647300|>mysql.server+start|4647301|现在可以工作了。希望这能有所帮助。这大约需要3个小时的试验和错误。|4647302|entityMap^0|L|K|0|0|0|0|0|0|0|0|2|4|0|M|K|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1M|8|@$9|1N|A|1O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|1P|8|@]|D|@]|E|$]]|$1|H|3|I|5|6|7|1Q|8|@]|D|@]|E|$]]|$1|J|3|K|5|6|7|1R|8|@]|D|@]|E|$]]|$1|L|3|M|5|N|7|1S|8|@]|D|@]|E|$O|P]]|$1|Q|3|R|5|6|7|1T|8|@]|D|@]|E|$]]|$1|S|3|T|5|6|7|1U|8|@]|D|@]|E|$]]|$1|U|3|V|5|N|7|1V|8|@]|D|@]|E|$O|P]]|$1|W|3|X|5|6|7|1W|8|@$9|1X|A|1Y|B|C]]|D|@]|E|$]]|$1|Y|3|Z|5|6|7|1Z|8|@$9|20|A|21|B|C]]|D|@]|E|$]]|$1|10|3|11|5|6|7|22|8|@]|D|@]|E|$]]|$1|12|3|13|5|N|7|23|8|@]|D|@]|E|$O|P]]|$1|14|3|15|5|6|7|24|8|@]|D|@]|E|$]]|$1|16|3|17|5|6|7|25|8|@]|D|@]|E|$]]|$1|18|3|19|5|N|7|26|8|@]|D|@]|E|$O|P]]|$1|1A|3|1B|5|6|7|27|8|@]|D|@]|E|$]]|$1|1C|3|1D|5|N|7|28|8|@]|D|@]|E|$O|P]]|$1|1E|3|1F|5|6|7|29|8|@]|D|@]|E|$]]|$1|1G|3|1H|5|N|7|2A|8|@]|D|@]|E|$O|P]]|$1|1I|3|1J|5|6|7|2B|8|@]|D|@]|E|$]]|$1|1K|3|-4|5|6|7|2C|8|@]|D|@]|E|$]]]|1L|$]]

First, knowing where the data directory was for me was the key. <code>/usr/local/var/mysql</code>
In here, there was at least one file with extension .err preceded with my local machine name. It had all info i needed to diagnose.

I think i screwed up by installing mysql 8 first. My app isn't compatible with it so i had to downgrade back to 5.7

My solution that worked for me was going to 
/usr/local/etc/my.cnf

Find this line if its there. I think its mysql 8 related:

<pre><code>mysqlx-bind-address = 127.0.0.1 
</code></pre>

Remove it because in the mysql 5.7 says it doesnt like it in the error log

Also add this line in there if its not there under the bind-address.

<pre><code>socket=/tmp/mysql.sock
</code></pre>

Go to the <code>/tmp</code> directory and delete any mysql.sock files in there. On server start, it will recreate the sock files

Trash out the data directory with mySQL in the stopped state. Mine was <code>/usr/local/var/mysql</code> . This is the same place where the logs are at

From there i ran 

<pre><code>&gt;mysqld --initialize
</code></pre>

Then everything started working...this command will give you a random password at the end. Save that password for the next step

Running this to assign my own password.

<pre><code>&gt;mysql_secure_installation 
</code></pre>

Both 

<pre><code>&gt;brew services stop mysql@5.7
</code></pre>

and

<pre><code>&gt;mysql.server start
</code></pre>

are now working. Hope this helps. It's about 3 hours of trial and error.

blocks|key|140915|text|从终端停止和启动mysql服务器解决了我的问题。下面是在MacOs中停止和启动mysql服务器的cmds。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|140916|sudo+/usr/local/mysql/support-files/mysql.server+stop
sudo+/usr/local/mysql/support-files/mysql.server+start|code-block|syntax|javascript|140917|注:从mac系统首选项重新启动服务不能解决我的Mac中的问题。所以尝试从终端重新启动。|140918|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Stoping and starting the mysql server from terminal resolved my issue.
Below are the cmds to stop and start the mysql server in MacOs.

<pre><code>sudo /usr/local/mysql/support-files/mysql.server stop
sudo /usr/local/mysql/support-files/mysql.server start
</code></pre>

Note:
Restarting the services from Mac System preference didn't resolve the issue in my mac. So try to restart from terminal.

blocks|key|140498|text|对于CentOS，初始化mysql的文件位于：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|140499|/etc/init.d/mysqld+start|code-block|syntax|javascript|140500|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

For CentOS, the file to init mysql is located here:

<pre><code>/etc/init.d/mysqld start
</code></pre>

blocks|key|4647235|text|我花了很多时间这样做，我想把我的django应用程序放在我的服务器上，当我运行python+manage.py+migrate时，我遇到了这样的问题|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4647236|还有！！我设置了这个ln+-s+/var/run/mysqld/mysqld.sock+/tmp/mysql.sock，它终于起作用了！|4647237|entityMap^0|13|O|0|A|1D|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|P|8|@]|D|@]|E|$]]]|I|$]]

I have spent lots of time doing this
I want to put my django app on my server and when I run <code>python manage.py migrate</code> I met this questions

And!! I set this
<code>ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock</code> 
It worked finally!

blocks|key|4647546|text|我也遇到过同样的问题。下面是我修复它的方法。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4647547|步骤1:使用以下命令删除mysql：|4647548|brew+uninstall+--force+mysql|code-block|syntax|javascript|4647549|步骤2:运行命令brew+doctor，该命令将为您提供一些与brew软件包相关的提示。|offset|length|style|CODE|4647550|第3步:使用以下命令清理brew软件包：|4647551|brew+cleanup|4647552|步骤4:使用以下命令移动/删除先前安装的mysql数据：|4647553|mv+/usr/local/var/mysql/+/usr/local/var/old_mysql|4647554|步骤5:最后使用以下命令重新安装mysql：|4647555|brew+install+mysql|4647556|entityMap^0|0|0|0|8|B|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|13|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|14|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|15|8|@$K|16|L|17|M|N]]|9|@]|A|$]]|$1|O|3|P|5|6|7|18|8|@]|9|@]|A|$]]|$1|Q|3|R|5|F|7|19|8|@]|9|@]|A|$G|H]]|$1|S|3|T|5|6|7|1A|8|@]|9|@]|A|$]]|$1|U|3|V|5|F|7|1B|8|@]|9|@]|A|$G|H]]|$1|W|3|X|5|6|7|1C|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|F|7|1D|8|@]|9|@]|A|$G|H]]|$1|10|3|-4|5|6|7|1E|8|@]|9|@]|A|$]]]|11|$]]

I have faced the same issue. Here is how I have fixed it.
Step 1: Remove mysql using command:
<pre><code>brew uninstall --force mysql
</code></pre>
Step 2: Run command <code>brew doctor</code> which will give you some hint related to your brew packages.
Step 3: Cleanup brew packages using command:
<pre><code>brew cleanup
</code></pre>
Step 4: Move/delete previously installed mysql data using command:
<pre><code>mv /usr/local/var/mysql/ /usr/local/var/old_mysql
</code></pre>
Step 5: Finally install mysql again using command:
<pre><code>brew install mysql
</code></pre>

blocks|key|140974|text|如果你在macOS上运行，首先检查一下“系统偏好设置”，看看MySQL是否在运行，这样会更容易一些。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|140975|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

If you're running on a macOS it's just easier to first check go to 'System Preferences' and see if MySQL is running or not.

I have installed MySQL server and trying to connect to it, but getting the error: 

<pre><code> Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
</code></pre>

I have checked my /tmp directory and there is no mysql.sock. I can't find mysql.sock anywhere. I read that it might be in 

<pre><code> /var/lib/mysql/mysql.sock
</code></pre>

But I checked there as well and there is even no mysql directory, only some postfix thing inside /lib. Could anyone help me with this problem?

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

数据库

服务器

Django

CentOS

MySQL

我已经安装了MySQL服务器，并尝试连接到它，但收到错误：    Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)我已经检查了我的/tmp目录，没有mysql.sock。我到处都找不到mysql.sock。我读到它可能在    /var/lib/mysql/mysql.sock但我也检查过了，那里甚至没

问无法通过套接字'/tmp/mysql.sock‘连接到本地MySQL服务器(2)
EN

回答 18

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问无法通过套接字'/tmp/mysql.sock‘连接到本地MySQL服务器(2)EN

回答 18

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问无法通过套接字'/tmp/mysql.sock‘连接到本地MySQL服务器(2)
EN