blocks|key|194096|text|这可能是因为MySQL已经安装，但尚未运行。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|194097|要验证它是否正在运行，请打开Activity+Monitor，然后在“所有进程”下搜索并验证您是否看到进程"mysqld“。|194098|你可以通过安装"MySQL.prefPane“来启动它。|194099|这是对我有帮助的完整教程：http://obscuredclarity.blogspot.in/2009/08/install-mysql-on-mac-os-x.html|offset|length|194100|entityMap|0|LINK|mutability|MUTABLE|url|http://obscuredclarity.blogspot.in/2009/08/install-mysql-on-mac-os-x.html^0|0|0|0|D|21|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@$H|V|I|W|1|X]]|A|$]]|$1|J|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q]]]]

It's probably because MySQL is installed but not yet running.

To verify that it's running, open up Activity Monitor and under "All Processes", search and verify you see the process "mysqld".

You can start it by installing "MySQL.prefPane".

Here is the complete tutorial which helped me:
<a href="http://obscuredclarity.blogspot.in/2009/08/install-mysql-on-mac-os-x.html">http://obscuredclarity.blogspot.in/2009/08/install-mysql-on-mac-os-x.html</a>

blocks|key|3031979|text|在终端上使用mysql命令之前，您需要启动MySQL。为此，请运行brew+services+start+mysql。默认情况下，brew安装MySQL数据库时不使用超级用户密码。要保护它，请运行：mysql_secure_installation。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3031980|要连接run：mysql+-uroot。root是这里的用户名。|3031981|entityMap^0|6|5|X|P|2R|P|0|7|C|K|4|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]|$9|M|A|N|B|C]|$9|O|A|P|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|Q|8|@$9|R|A|S|B|C]|$9|T|A|U|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|V|8|@]|D|@]|E|$]]]|I|$]]

You'll need to start MySQL before you can use the <code>mysql</code> command on your terminal. To do this, run <code>brew services start mysql</code>. By default, brew installs the MySQL database without a root password. To secure it run: <code>mysql_secure_installation</code>.

To connect run: <code>mysql -uroot</code>. <code>root</code> is the username name here.

blocks|key|3031991|text|这发生在自制软件安装之后，并且由于权限问题而发生。以下命令修复了该问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3031992|sudo+chown+-R+_mysql:mysql+/usr/local/var/mysql

sudo+mysql.server+start|code-block|syntax|javascript|3031993|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|$]]

This happened after the homebrew install and occurs due to permission issues. The following commands fixed the issue.

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

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

blocks|key|3031828|text|运行：brew+info+mysql|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3031829|并按照说明进行操作。从公式中的描述可以看出：|3031830|Set+up+databases+to+run+AS+YOUR+USER+ACCOUNT+with:
++++unset+TMPDIR
++++mysql_install_db+--verbose+--user=`whoami`+--basedir="$(brew+--prefix+mysql)"+--datadir=/usr/local/var/mysql+--tmpdir=/tmp

To+set+up+base+tables+in+another+folder,+or+use+a+different+user+to+run
mysqld,+view+the+help+for+mysql_install_db:
++++mysql_install_db+--help

and+view+the+MySQL+documentation:
++*+http://dev.mysql.com/doc/refman/5.5/en/mysql-install-db.html
++*+http://dev.mysql.com/doc/refman/5.5/en/default-privileges.html|code-block|syntax|javascript|3031831|希望这能有所帮助。|3031832|entityMap^0|3|F|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|T|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|U|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|V|8|@]|D|@]|E|$]]|$1|O|3|-4|5|6|7|W|8|@]|D|@]|E|$]]]|P|$]]

Run: <code>brew info mysql</code>

And follow the instructions. From the description in the formula:

<pre class="lang-none prettyprint-override"><code>Set up databases to run AS YOUR USER ACCOUNT with:
 unset TMPDIR
 mysql_install_db --verbose --user=`whoami` --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp

To set up base tables in another folder, or use a different user to run
mysqld, view the help for mysql_install_db:
 mysql_install_db --help

and view the MySQL documentation:
 * http://dev.mysql.com/doc/refman/5.5/en/mysql-install-db.html
 * http://dev.mysql.com/doc/refman/5.5/en/default-privileges.html
</code></pre>

Hope this helps.

blocks|key|196627|text|正如其他人所指出的那样，这是因为MySQL已经安装，但该服务并未运行。有许多方法可以启动MySQL服务，对我有效的方法如下所示。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|196628|启动服务的步骤：|196629|196630|转到"System+Preference“|ordered-list-item|196631|在底部窗格中应该有MySql图标。|196632|双击该按钮以启动“MySQL服务器状态”，然后按按钮“启动MySQL服务器”|196633|196634|我的环境：|196635|Mac+Yosemite+10.10.3|196636|安装包:/Volumes/mysql-advanced+5.6.24-osx10.8-x86_64|196637|entityMap^0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|W|8|@]|9|@]|A|$]]|$1|E|3|F|5|G|7|X|8|@]|9|@]|A|$]]|$1|H|3|I|5|G|7|Y|8|@]|9|@]|A|$]]|$1|J|3|K|5|G|7|Z|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|10|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|11|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|12|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|13|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|T|$]]

As others have pointed out this is because MySQL is installed but the service isn't running. There are many ways to start the MySQL service and what worked for me is the below.

To start the service:

<ol>
<li>Go to "System Preference"</li>
<li>At the bottom pane there should be MySql icon. </li>
<li>Double click that to launch the 'MySQL Server Status' and press the button 'Start MySQL Server' </li>
</ol>

My env:

Mac Yosemite 10.10.3

Installed Package: /Volumes/mysql-advanced-5.6.24-osx10.8-x86_64

blocks|key|196666|text|解决方案围绕以下几个方面：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|196667|196668|更改MySQL的权限|unordered-list-item|196669|196670|/usr/local/var/mysql|196671|Starting+a+MySQL进程的sudo+chown+-R+_mysql:mysql|196672|196673|sudo+mysql.server启动|196674|如果上面的命令不能为您解决这个问题，那么可以尝试指定主机，这是在许多不同的帖子中为您提供了许多有用的答案。|offset|length|style|BOLD|196675|mysql+-u+root+-p+h127.0.0.1|code-block|syntax|javascript|196676|entityMap^0|0|0|0|0|0|0|0|0|K|8|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|11|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|12|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|13|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|14|8|@]|9|@]|A|$]]|$1|I|3|J|5|E|7|15|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|16|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|17|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|18|8|@$P|19|Q|1A|R|S]]|9|@]|A|$]]|$1|T|3|U|5|V|7|1B|8|@]|9|@]|A|$W|X]]|$1|Y|3|-4|5|6|7|1C|8|@]|9|@]|A|$]]]|Z|$]]

Solutions revolve around:

<ul>
<li>changing MySQL's permissions

<pre><code>sudo chown -R _mysql:mysql /usr/local/var/mysql
</code></pre></li>
<li>Starting a MySQL process

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

Just to add on a lot of great and useful answers that have been provided <a href="https://stackoverflow.com/questions/15450091/for-a-newbie-error-2002-hy000-cant-connect-to-local-mysql-server-through-so">here</a> and from many different posts, try specifying the host if the above commands did not resolve this issue for you, i.e 

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

blocks|key|2819479|text|警告-此方法将删除/usr/local/var/mysql文件夹中的所有数据库|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2819480|我在Homebrew上安装了MySQL，唯一能解决这个问题的就是重新安装MySQL。|2819481|在我公司的笔记本电脑上，我没有权限通过Homebrew从我的电脑上卸载MySQL：|2819482|$+brew+uninstall+mysql+--ignore-dependencies
Uninstalling+/usr/local/Cellar/mysql/8.0.12...+(255+files,+233.0MB)
Error:+Permission+denied+@+dir_s_rmdir+-+/usr/local/Cellar/mysql/8.0.12|code-block|syntax|javascript|2819483|因此，我手动删除并重新安装了MySQL：|2819484|$+sudo+rm+-rf+/usr/local/Cellar/mysql
$+brew+cleanup
$+sudo+rm+-rf+/usr/local/var/mysql
$+brew+install+mysql|2819485|这就成功了！|2819486|entityMap^0|9|K|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|Z|8|@]|D|@]|E|$]]|$1|H|3|I|5|6|7|10|8|@]|D|@]|E|$]]|$1|J|3|K|5|L|7|11|8|@]|D|@]|E|$M|N]]|$1|O|3|P|5|6|7|12|8|@]|D|@]|E|$]]|$1|Q|3|R|5|L|7|13|8|@]|D|@]|E|$M|N]]|$1|S|3|T|5|6|7|14|8|@]|D|@]|E|$]]|$1|U|3|-4|5|6|7|15|8|@]|D|@]|E|$]]]|V|$]]

<h2>Warning - this method will remove all of your databases in the <code>/usr/local/var/mysql</code> folder</h2>
I had MySQL installed with Homebrew, and the only thing that fixed this for me was re-installing MySQL.
On my company laptop, I didn't have permission to uninstall MySQL from my computer via Homebrew:
<pre><code>$ brew uninstall mysql --ignore-dependencies
Uninstalling /usr/local/Cellar/mysql/8.0.12... (255 files, 233.0MB)
Error: Permission denied @ dir_s_rmdir - /usr/local/Cellar/mysql/8.0.12
</code></pre>
So instead, I removed and reinstalled MySQL manually:
<pre><code>$ sudo rm -rf /usr/local/Cellar/mysql
$ brew cleanup
$ sudo rm -rf /usr/local/var/mysql
$ brew install mysql
</code></pre>
And that worked!

blocks|key|3032054|text|看起来您的mysql服务器尚未启动。我通常会运行stop命令，然后再次启动它：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3032055|mysqld+stop
mysql.server+start|code-block|syntax|javascript|3032056|同样的错误，这也适用于我。|3032057|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|$]]

Looks like your mysql server is not started. I usually run the stop command and then start it again:

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

Same error, and this works for me.

blocks|key|192324|text|下面是来自brew+install+mysql的最新说明，以便对此问题进行更新的搜索可以受益：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|192325|$+brew+install+mysql
==>+Downloading+https://homebrew.bintray.com/bottles/mysql-5.6.26.yosemite.bottle.1.tar.gz
########################################################################+100.0%25
==>+Pouring+mysql-5.6.26.yosemite.bottle.1.tar.gz

To+connect:
++++mysql+-uroot

To+have+launchd+start+mysql+at+login:
++ln+-sfv+/usr/local/opt/mysql/*.plist+~/Library/LaunchAgents
Then+to+load+mysql+now:
++launchctl+load+~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
Or,+if+you+don't+want/need+launchctl,+you+can+just+run:
++mysql.server+start|code-block|syntax|javascript|192326|在我的例子中，我现在通过launchctl+load+~/Library/LaunchAgents/homebrew.mxcl.mysql.plist加载了mysql，然后能够启动$+mysql并上路了。|192327|我希望这对最近的疑难解答有帮助！|192328|entityMap^0|5|I|0|0|C|1R|2I|7|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|T|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|U|8|@$9|V|A|W|B|C]|$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|M|3|N|5|6|7|Z|8|@]|D|@]|E|$]]|$1|O|3|-4|5|6|7|10|8|@]|D|@]|E|$]]]|P|$]]

Below I'm including the latest instructions from <code>brew install mysql</code> so newer searches for this issue can benefit:

<pre><code>$ brew install mysql
==&gt; Downloading https://homebrew.bintray.com/bottles/mysql-5.6.26.yosemite.bottle.1.tar.gz
######################################################################## 100.0%
==&gt; Pouring mysql-5.6.26.yosemite.bottle.1.tar.gz

To connect:
 mysql -uroot

To have launchd start mysql at login:
 ln -sfv /usr/local/opt/mysql/*.plist ~/Library/LaunchAgents
Then to load mysql now:
 launchctl load ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
Or, if you don't want/need launchctl, you can just run:
 mysql.server start
</code></pre>

In my case I loaded mysql now via <code>launchctl load ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist</code> and was then able to launch <code>$ mysql</code> and be on my way.

I hope this helps recent troubleshooters!

blocks|key|196849|text|这个问题与/usr/local/var/mysql文件夹访问有关，我删除此文件夹并重装mysql。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|196850|196851|卸载带有brew的mysql：|ordered-list-item|196852|196853|brew+uninstall+mysql|196854|sudo+rm+-r+/usr/local/var/mysql|unordered-list-item|196855|
|196856|brew+install+mysql@8.0|196857|196858|mysql+-u+root|196859|196860|这个解决方案对我来说很好！，但是你丢失了所有的数据库！警告！|BOLD|196861|entityMap^0|5|K|0|0|0|0|0|K|0|0|V|0|0|0|M|0|0|0|D|0|0|D|H|0^^$0|@$1|2|3|4|5|6|7|12|8|@$9|13|A|14|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|15|8|@]|D|@]|E|$]]|$1|G|3|H|5|I|7|16|8|@]|D|@]|E|$]]|$1|J|3|-4|5|6|7|17|8|@]|D|@]|E|$]]|$1|K|3|L|5|6|7|18|8|@$9|19|A|1A|B|C]]|D|@]|E|$]]|$1|M|3|N|5|O|7|1B|8|@$9|1C|A|1D|B|C]]|D|@]|E|$]]|$1|P|3|Q|5|6|7|1E|8|@]|D|@]|E|$]]|$1|R|3|S|5|O|7|1F|8|@$9|1G|A|1H|B|C]]|D|@]|E|$]]|$1|T|3|Q|5|6|7|1I|8|@]|D|@]|E|$]]|$1|U|3|V|5|O|7|1J|8|@$9|1K|A|1L|B|C]]|D|@]|E|$]]|$1|W|3|-4|5|6|7|1M|8|@]|D|@]|E|$]]|$1|X|3|Y|5|6|7|1N|8|@$9|1O|A|1P|B|Z]]|D|@]|E|$]]|$1|10|3|-4|5|6|7|1Q|8|@]|D|@]|E|$]]]|11|$]]

this problem related to <code>/usr/local/var/mysql</code> folder access, I remove this folder and reinstall mysql.

<ol>
<li>uninstall mysql with brew :

<code>brew uninstall mysql</code></li>
<li><code>sudo rm -r /usr/local/var/mysql</code></li>
<li><code>brew install mysql@8.0</code></li>
<li><code>mysql -u root</code></li>
</ol>

This solution works fine for me!
BUT YOU LOST ALL YOUR DATABASES! WARNING!

blocks|key|3032077|text|这解决了我重启mysql服务时的问题。只需运行：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3032078|brew+services+start+mysql|code-block|syntax|javascript|3032079|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|$]]

This fixed my issue when I restarted the mysql service. Just run:

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

blocks|key|192507|text|我花了一段时间才弄明白。我在一条评论中看到了。使用brew安装mysql并启动服务(可能使用sudo+brew+services+start+mysql)后，运行：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|192508|$+mysqld|code-block|syntax|javascript|192509|之后，MySQL应该会为您运行。|192510|entityMap^0|1A|U|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|R|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|S|8|@]|D|@]|E|$]]|$1|M|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|N|$]]

Ough, that took me a while to figure out. I saw it in a comment. After installing mysql using brew, and starting the service (perhaps using <code>sudo brew services start mysql</code>) then run:

<pre><code>$ mysqld
</code></pre>

And MySQL should be running for your thereafter.

blocks|key|192807|text|指定的数据目录/usr/local/var/mysql/不可用。您可以删除服务器添加到其中的所有文件。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|192808|​|192809|MacOS:
$brew+services+stop+mysql
$brew+services+list
$brew+uninstall++mysql

$brew+install+mysql
$brew+postinstall+mysql

If+Any+error+found+then+run+those+cmd
$sudo+rm+-rf+/usr/local/var/mysql
$sudo+rm+/usr/local/etc/my.cnf
$brew+postinstall+mysql


$brew+services+start+mysql
$mysql_secure_installation|code-block|syntax|javascript|192810|📷|atomic|offset|length|192811|已完成安全安装的所有过程，然后运行|192812|192813|$mysql+-u+root+-p|192814|恭喜您已经设置好了mysql！|192815|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/d216f2ff3f7d1659ab42734b592181c2.png|imageAlt^0|0|0|0|0|1|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|13|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|14|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|15|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|K|7|16|8|@]|9|@$L|17|M|18|1|19]]|A|$]]|$1|N|3|O|5|6|7|1A|8|@]|9|@]|A|$]]|$1|P|3|C|5|6|7|1B|8|@]|9|@]|A|$]]|$1|Q|3|R|5|F|7|1C|8|@]|9|@]|A|$G|H]]|$1|S|3|T|5|6|7|1D|8|@]|9|@]|A|$]]|$1|U|3|-4|5|6|7|1E|8|@]|9|@]|A|$]]]|V|$W|$5|X|Y|Z|A|$10|11|12|-4]]]]

The designated data directory /usr/local/var/mysql/ is unusable. You can remove all files that the server added to it.
<div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
<div class="snippet-code">
<pre class="snippet-code-js lang-js prettyprint-override"><code>MacOS:
$brew services stop mysql
$brew services list
$brew uninstall mysql

$brew install mysql
$brew postinstall mysql

If Any error found then run those cmd
$sudo rm -rf /usr/local/var/mysql
$sudo rm /usr/local/etc/my.cnf
$brew postinstall mysql


$brew services start mysql
$mysql_secure_installation</code></pre>
</div>
</div>

<a href="https://i.stack.imgur.com/5tYLj.png" rel="noreferrer"><img src="https://i.stack.imgur.com/5tYLj.png" alt="enter image description here" /></a>
Completed All process of secure installation then run
<pre><code>$mysql -u root -p
</code></pre>
Congratulations you’ve just set up mysql!

blocks|key|2819337|text|对我来说，这很简单，就像跑步：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2819338|/usr/local/opt/mysql/bin/mysqld_safe|offset|length|style|CODE|2819339|代替mysqld|2819340|entityMap^0|0|0|10|0|2|6|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@$D|N|E|O|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@$D|Q|E|R|F|G]]|9|@]|A|$]]|$1|J|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|K|$]]

For me it was simple as running:

<code>/usr/local/opt/mysql/bin/mysqld_safe</code>

instead of <code>mysqld</code>

blocks|key|3032116|text|在我的例子中，这只是一个简单的删除锁文件的问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3032117|sudo+rm+-f+/tmp/mysql.sock.lock|code-block|syntax|javascript|3032118|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|$]]

In my case it was simply a matter of deleting a lock file.

<pre><code>sudo rm -f /tmp/mysql.sock.lock
</code></pre>

blocks|key|194503|text|我找到了我的问题的解决方案。这确实是因为我的MySQL服务器没有运行。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|194504|这是由于MySQL没有在我的机器上正确设置，因此无法运行。|194505|为了解决这个问题，我使用了一个在Mac+Lion上安装MySQL的脚本，它肯定安装了丢失的文件。|offset|length|style|BOLD|194506|这是链接：http://code.macminivault.com/|194507|重要说明：此脚本将超级用户密码设置为随机生成的字符串，并将其保存在桌面上，因此请注意不要删除此文件并记下密码。它还会在您的系统首选项中安装MySQL管理器。我也不确定是否会删除任何现有的数据库，所以要小心。|194508|entityMap|0|LINK|mutability|MUTABLE|url|http://code.macminivault.com/^0|0|0|0|O|0|5|T|0|0|0|5|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|W|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|X|8|@$F|Y|G|Z|H|I]]|9|@]|A|$]]|$1|J|3|K|5|6|7|10|8|@]|9|@$F|11|G|12|1|13]]|A|$]]|$1|L|3|M|5|6|7|14|8|@$F|15|G|16|H|I]]|9|@]|A|$]]|$1|N|3|-4|5|6|7|17|8|@]|9|@]|A|$]]]|O|$P|$5|Q|R|S|A|$T|U]]]]

I found the solution to my problem. It was indeed because my MySQL server was not running.

It was caused by MySQL not being correctly set up on my machine, thus not being able to run.

To remedy this, I used a script which installs MySQL on Mac OSX Mountain Lion, which must have installed missing files.

Here is the link: <a href="http://code.macminivault.com/" rel="nofollow">http://code.macminivault.com/</a>

Important Note: This script sets the root password as a randomly generated string, which it saves on the Desktop, so take care not to delete this file and to note the password. It also installs MySQL manager in your system preferences. I'm also not sure if removes any existing databases, so be careful about that.

blocks|key|2819442|text|在这方面工作了几个小时之后，对我起作用的是转到/etc/mysql/并编辑my.cnf文件。添加以下内容|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2819443|[client]
port+=+3306
socket+=+/var/run/mysqld/mysqld.sock|code-block|syntax|javascript|2819444|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|$]]

After working on this for several hours what worked for me was
go to /etc/mysql/ and edit the my.cnf file. Add the following

<pre><code>[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
</code></pre>

blocks|key|3032400|text|我解决了这个问题，并使用以下解决方案成功运行了mysql服务器|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3032401|通过.dmg(https://dev.mysql.com/downloads/mysql/5.7.html)安装mysql，您将在系统偏好设置中找到mysql服务面板，然后从面板启动mysql并尝试|offset|length|style|CODE|3032402|mysql+-u+root+-p|3032403|附图供参考|3032404|​|3032405|📷|atomic|3032406|3032407|3032408|3032409|3032410|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/downloads/mysql/5.7.html|1|IMAGE|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/9084f470ca521b897810397433d326e3.png|imageAlt|2|https://ask.qcloudimg.com/http-save/yehe-900000/34f28b2bf1f3260db584b339f19ed9fb.png^0|0|2|4|7|1A|0|0|0|G|0|0|0|0|1|1|0|0|0|0|1|2|0|0^^$0|@$1|2|3|4|5|6|7|1A|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1B|8|@$D|1C|E|1D|F|G]]|9|@$D|1E|E|1F|1|1G]]|A|$]]|$1|H|3|I|5|6|7|1H|8|@$D|1I|E|1J|F|G]]|9|@]|A|$]]|$1|J|3|K|5|6|7|1K|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|1L|8|@]|9|@]|A|$]]|$1|N|3|O|5|P|7|1M|8|@]|9|@$D|1N|E|1O|1|1P]]|A|$]]|$1|Q|3|M|5|6|7|1Q|8|@]|9|@]|A|$]]|$1|R|3|M|5|6|7|1R|8|@]|9|@]|A|$]]|$1|S|3|O|5|P|7|1S|8|@]|9|@$D|1T|E|1U|1|1V]]|A|$]]|$1|T|3|M|5|6|7|1W|8|@]|9|@]|A|$]]|$1|U|3|-4|5|6|7|1X|8|@]|9|@]|A|$]]]|V|$W|$5|X|Y|Z|A|$10|11]]|12|$5|13|Y|14|A|$15|16|17|-4]]|18|$5|13|Y|14|A|$15|19|17|-4]]]]

I went through this issue and I managed to run mysql server using below solution

Install mysql through <code>.dmg</code>(<a href="https://dev.mysql.com/downloads/mysql/5.7.html" rel="nofollow noreferrer">https://dev.mysql.com/downloads/mysql/5.7.html</a>), you will get mysql service panel in system preferences then start mysql from the panel and try 

<code>mysql -u root -p</code>

Images attached for reference

<a href="https://i.stack.imgur.com/h6gqA.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/h6gqA.png" alt="System Preferences"></a>

<a href="https://i.stack.imgur.com/zNpcr.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/zNpcr.png" alt="Mysql panel"></a>

blocks|key|2819652|text|我已经尝试了所有可能的方法来解决这个问题，比如ln+-s+/var/lib/+mysql+/mysql.sock+/tmp/mysql.sock，卸载并重新安装mysql，确保mysql在xampp上运行，但都不起作用。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2819653|最后，我打开my.cnf+(配置文件)并复制套接字路径(确保复制完整路径，否则将无法工作)。然后，我在我的终端中执行这个命令|2819654|mysql+--socket=/Applications/XAMPP/xamppfiles/var/mysql/mysql.sock|code-block|syntax|javascript|2819655|瞧，mysql启动了。|2819656|只有当您的MySQL显示在Xampp/Ampps上运行时，此解决方案才有效，但在终端中，当您已经尝试执行以下操作时，它仍未连接到正确的插座：|2819657|./mysql+-u+root|2819658|或|2819659|brew+services+start+mysql|2819660|我希望这能帮到你!|2819661|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|6|7|X|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Y|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|Z|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|10|8|@]|9|@]|A|$]]|$1|M|3|N|5|F|7|11|8|@]|9|@]|A|$G|H]]|$1|O|3|P|5|6|7|12|8|@]|9|@]|A|$]]|$1|Q|3|R|5|F|7|13|8|@]|9|@]|A|$G|H]]|$1|S|3|T|5|6|7|14|8|@]|9|@]|A|$]]|$1|U|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|V|$]]

I have tried every possible way to solve this issue, like ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock, uninstall and reinstall mysql, make sure mysql is running on xampp but none of it still worked. 

Finally, I open up my.cnf (config file) and copy the socket path (make sure to copy the full path else it won't work). Then I perform this command in my terminal

<pre><code>mysql --socket=/Applications/XAMPP/xamppfiles/var/mysql/mysql.sock
</code></pre>

Lo, and behold, mysql launchs.

This solution will only work if your MySQL is shown running on Xampp/Ampps, but in terminal it is still not connecting to the right socket when you have already attempted something like:

<pre><code>./mysql -u root
</code></pre>

or

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

I hope this helps!

blocks|key|3032472|text|只有这样才能让我学会brew+services+start+--all+(在尝试了所有答案之后)|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3032473|entityMap^0|A|P|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

only this has made the trick for me
<code>brew services start --all</code>
(after trying all answers)

blocks|key|194421|text|我建议你跑|type|unstyled|depth|inlineStyleRanges|entityRanges|data|194422|++mysql.server+start|code-block|syntax|javascript|194423|在访问之前|194424|++mysql+-u+root+-p|194425|以便在尝试登录mysql服务器之前确保该服务器正在运行|194426|当您启动/重新启动一台没有运行mysql服务器的机器时，这种情况会发生很多次。|194427|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|$]]

I would recommend you to run 

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

before going to 

<pre><code> mysql -u root -p
</code></pre>

so as to make sure that the mysql server is running before trying to login into it 

This happens many times what you start/restart a machine where by no mysql server is running.

blocks|key|2819850|text|我不断地回到这篇文章，我已经遇到这个错误好几次了。这可能与执行全新安装后导入所有数据库有关。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2819851|我用的是自制的。唯一能帮我解决这个问题的是：|2819852|sudo+mkdir+/var/mysql
sudo+ln+-s+/tmp/mysql.sock+/var/mysql/mysql.sock|code-block|syntax|javascript|2819853|今天早上，在我的机器决定连夜关机后，问题又出现了。现在解决这个问题的唯一办法就是升级mysql。|2819854|brew+upgrade+mysql|2819855|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

I keep coming back to this post, I've encountered this error several times. It might have to do with importing all my databases after doing a fresh install.

I'm using homebrew. The only thing that used to fix it for me:

<pre><code>sudo mkdir /var/mysql
sudo ln -s /tmp/mysql.sock /var/mysql/mysql.sock
</code></pre>

This morning, the issue returned after my machine decided to shut down overnight. The only thing that fixed it now was to upgrade mysql.

<pre><code>brew upgrade mysql
</code></pre>

blocks|key|2819910|text|在尝试了许多解决方案后，似乎最终成功的解决方案是通过IP连接。不再随机删除文件套接字。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2819911|只需使用以下命令更新您的MySQL客户端配置(例如/usr/local/etc/my.cnf)：|offset|length|style|CODE|2819912|[client]
port+=+3306
host=127.0.0.1
protocol=tcp|code-block|syntax|javascript|2819913|entityMap^0|0|P|L|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@$D|Q|E|R|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|S|8|@]|9|@]|A|$K|L]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

After trying many solutions, seems like the one that finally did the trick was to connect by IP. No longer file sockets getting deleted randomly.

Just update your MySQL client config (e.g. <code>/usr/local/etc/my.cnf</code>) with:

<pre><code>[client]
port = 3306
host=127.0.0.1
protocol=tcp
</code></pre>

blocks|key|197058|text|在使用了上面的所有解决方案后，没有任何东西对我起作用，但是这个起作用了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|197059|I您已使用HomeBrew安装了MySQL，然后在mac中检查系统偏好设置>+MySQL是否已停止MySQL服务器(如果它正在运行)停止它|offset|length|style|BOLD|197060|📷|atomic|197061|通过单击停止MySQL服务器并从终端启动MySQL，编写命令mysqlserver.start。|CODE|197062|如果它不起作用，你也可以尝试：|197063|如果您还安装了MySQL+workbench，则只需卸载MySQL+workbench和MySQL，然后先安装MySQL，然后安装MySQL+workbench。|197064|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/d3062e04a35d36feab69d6e85eded0ca.png|imageAlt^0|0|V|D|0|0|1|0|0|4|A|U|H|0|0|S|L|1J|Q|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|11|8|@$D|12|E|13|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|14|8|@]|9|@$D|15|E|16|1|17]]|A|$]]|$1|K|3|L|5|6|7|18|8|@$D|19|E|1A|F|G]|$D|1B|E|1C|F|M]]|9|@]|A|$]]|$1|N|3|O|5|6|7|1D|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1E|8|@$D|1F|E|1G|F|G]|$D|1H|E|1I|F|G]]|9|@]|A|$]]|$1|R|3|-4|5|6|7|1J|8|@]|9|@]|A|$]]]|S|$T|$5|U|V|W|A|$X|Y|Z|-4]]]]

AFTER USING ALL THE ABOVE SOLUTIONS, NOTHING WORKED FOR ME BUT THIS WORKED.
I you have installed MySQL using HomeBrew then check System Preferences &gt; MySQL in your mac that MySQL Server is stopped if it is running stop it<a href="https://i.stack.imgur.com/bt8gp.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bt8gp.png" alt="enter image description here" /></a> by clicking on Stop MySQL Server and start MySQL from terminal writing the command <code>mysqlserver.start</code>.
If it doesn't work you can also try:-
If you have also installed MySQL workbench then just uninstall MySQL workbench and MySQL and after that install MySQL first and then MySQL workbench.

blocks|key|3032839|text|在安装自制mysql的过程中，您可能会遇到一些问题，mysql服务可能没有运行。如果是这样，那么可能值得尝试下面的步骤来正确地重新安装mysql，然后尝试连接。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3032840|sudo+chown+-R+$(whoami)+/usr/local/var

sudo+chown+-R+$(whoami)+/Library/Caches/Homebrew

brew+uninstall+mysql

brew+install+mysql

mysql.server+start+++

mysql+-uroot++|code-block|syntax|javascript|3032841|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|$]]

Probably you might have faced some issues during the homebrew mysql installation and mysql services might not be running. If that is the case, then it might be worth trying below steps to reinstall mysql properly and then try to connect.
<pre><code>sudo chown -R $(whoami) /usr/local/var

sudo chown -R $(whoami) /Library/Caches/Homebrew

brew uninstall mysql

brew install mysql

mysql.server start 

mysql -uroot 
</code></pre>

blocks|key|3031997|text|在我的例子中，在安装MAMP之后，从终端访问mysql给出了相同的套接字错误。最后，它想要的只是一次重启，而且它正在工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3031998|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|$]]

In my case right after installing the MAMP accessing mysql from the terminal was giving the same socket error. At the end all it wanted was a restart and it's working.

blocks|key|194258|text|这里有很多其他有帮助的回复，但对我来说都没有解决这个问题。归根结底，我在这个网站或其他网站上发现的任何版本的MySQL都不能为我工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|194259|只需从https://dev.mysql.com/downloads/file/?id=479114下载DMG+(找到您需要的适当版本)，并让向导为我安装它，这是非常轻松的。另一个手动步骤是将/usr/local/mysql/bin添加到我的路径中。|offset|length|style|CODE|194260|如果brew给您带来麻烦，我建议您使用此选项。|194261|更新-如果这仍然不能修复它，请在通过DMG安装之前尝试完全清除mysql。按照以下说明操作：https://gist.github.com/vitorbritto/0555879fe4414d18569d|194262|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/downloads/file/?id=479114|1|https://gist.github.com/vitorbritto/0555879fe4414d18569d^0|0|2O|K|3|1B|0|0|0|1A|1K|1|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|W|8|@$D|X|E|Y|F|G]]|9|@$D|Z|E|10|1|11]]|A|$]]|$1|H|3|I|5|6|7|12|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|13|8|@]|9|@$D|14|E|15|1|16]]|A|$]]|$1|L|3|-4|5|6|7|17|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|S]]|T|$5|O|P|Q|A|$R|U]]]]

A lot of other helpful responses here, but nothing fixed this for me. Ultimately nothing I found on this site or others would get any version of MySQL from Homebrew working for me.

It was super painless to just download the DMG from <a href="https://dev.mysql.com/downloads/file/?id=479114" rel="nofollow noreferrer">https://dev.mysql.com/downloads/file/?id=479114</a> (find the appropriate version you need) and let the wizard install it for me. The only other manual step was adding <code>/usr/local/mysql/bin</code> to my PATH.

I'd recommend this option if brew is giving you trouble.

Update - if this still doesn't fix it, try completely purging mysql before installing via DMG. Follow these instructions: <a href="https://gist.github.com/vitorbritto/0555879fe4414d18569d" rel="nofollow noreferrer">https://gist.github.com/vitorbritto/0555879fe4414d18569d</a>

blocks|key|2819775|text|尝尝这个|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2819776|rm+-rf+/usr/local/var/mysql+&&+brew+postinstall+mysql@5.7+&&+brew+services+restart+mysql@5.7|code-block|syntax|javascript|2819777|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

<pre><code>rm -rf /usr/local/var/mysql &amp;&amp; brew postinstall mysql@5.7 &amp;&amp; brew services restart mysql@5.7
</code></pre>

blocks|key|3032544|text|升级到Catalina操作系统后遇到类似问题。运行mysqld命令后，我发现日志文件有一些问题。对于其他人来说可能会有所不同。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3032545|$+mysqld|code-block|syntax|javascript|3032546|问题是|3032547|2019-10-16T04:58:59.174474Z+0+[ERROR]+Could+not+open+file+'/var/log/mysql/error.log'+for+error+logging:+No+such+file+or+directory
2019-10-16T04:58:59.174508Z+0+[ERROR]+Aborting|3032548|通过创建它并应用适当的权限解决了它。|3032549|sudo+mkdir+-p+/var/log/mysql
sudo+touch+/var/log/mysql/error.log
sudo+chown+-R+_mysql:mysql+/var/log/mysql/|3032550|重新启动MySQL|3032551|brew+services+restart+mysql@5.7|3032552|问题已解决。|3032553|mysql+-uroot+-proot|3032554|entityMap^0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|10|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|12|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|13|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|14|8|@]|9|@]|A|$]]|$1|Q|3|R|5|D|7|15|8|@]|9|@]|A|$E|F]]|$1|S|3|T|5|6|7|16|8|@]|9|@]|A|$]]|$1|U|3|V|5|D|7|17|8|@]|9|@]|A|$E|F]]|$1|W|3|-4|5|6|7|18|8|@]|9|@]|A|$]]]|X|$]]

Encountered a similar problem after upgrading to Catalina OS. After running mysqld command, I found that there was some issue with the logs file. It could be different for others.

<pre><code>$ mysqld
</code></pre>

Issue was

<pre><code>2019-10-16T04:58:59.174474Z 0 [ERROR] Could not open file '/var/log/mysql/error.log' for error logging: No such file or directory
2019-10-16T04:58:59.174508Z 0 [ERROR] Aborting
</code></pre>

Resolved it by creating it and applying proper permissions.

<pre><code>sudo mkdir -p /var/log/mysql
sudo touch /var/log/mysql/error.log
sudo chown -R _mysql:mysql /var/log/mysql/
</code></pre>

Restart MySQL

<pre><code>brew services restart mysql@5.7
</code></pre>

Issue was resolved.

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

blocks|key|3032605|text|在尝试了这些答案中的许多选项后，运行sudo+chown+_mysql+/usr/local/var/mysql/*终于帮了我大忙。权限问题可能是由于计算机的不正确关机引起的。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3032606|entityMap^0|I|14|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

Running <code>sudo chown _mysql /usr/local/var/mysql/*</code> helped me finally after trying multitude of options from all these SO answers. The issue with permissions probably arose from improper shutdown of the machine.

blocks|key|192747|text|在终端点击"brew+services+start+mysql“即可。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|192748|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|$]]

just hit &quot;brew services start mysql&quot; in terminal

blocks|key|194481|text|如果您使用的是OSX并安装了XAMPP，请执行以下步骤：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|194482|多亏了Jackstine的回答，我才能做到以下几点：|194483|$+cat+~/.my.cnf|194484|[mysql]

#+CLIENT+#
port+++++++++++++++++++++++++++=+3306
socket+++++++++++++++++++++++++=+/Applications/XAMPP/xamppfiles/var/mysql/mysql.sock|code-block|syntax|javascript|194485|我希望将来当我忘记的时候，这能再次帮助我！|194486|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Q|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|R|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

If you are on OSX and have XAMPP,then please follow these steps:
Thanks to Jackstine's answer, I was able to do the following:
$ cat ~/.my.cnf
<pre><code>[mysql]

# CLIENT #
port = 3306
socket = /Applications/XAMPP/xamppfiles/var/mysql/mysql.sock
</code></pre>
I hope this helps me again when I forget, in the future!

blocks|key|3032713|text|通过将localhost更改为127.0.0.1，我设法解决了这个问题|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3032714|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 managed to solve this issue by changing localhost to 127.0.0.1

blocks|key|3032757|text|在我的例子中，只需将host指定为127.0.0.1，而不是localhost：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3032758|$+bin/mysql+-uroot+-p+-h127.0.0.1
Enter+password:
Welcome+to+the+MySQL+monitor.++Commands+end+with+;+or+\g.
Your+MySQL+connection+id+is+8
Server+version:+8.0.26

Copyright+(c)+2000,+2021,+Oracle+and/or+its+affiliates.

Oracle+is+a+registered+trademark+of+Oracle+Corporation+and/or+its
affiliates.+Other+names+may+be+trademarks+of+their+respective
owners.

Type+'help;'+or+'\h'+for+help.+Type+'\c'+to+clear+the+current+input+statement.

mysql>|code-block|syntax|javascript|3032759|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 my case, just specify host as 127.0.0.1, instead of localhost:
<pre><code>$ bin/mysql -uroot -p -h127.0.0.1
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.26

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

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

blocks|key|2820269|text|Homebrew绝对不会使用标准的重新安装来修复权限，并且追查哪个文件夹/文件被损坏将花费比它值得的更长的时间。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2820270|在这种情况下-手动清除mysql安装，并通过自制软件重新安装。大约需要2分钟。|2820271|cd+/usr/local/var|offset|length|style|CODE|2820272|sudo+rm+-rf+mysql|2820273|brew+install+mysql|2820274|默认情况下，Homebrew安装的mysql是不安全的，所以如果您需要密码：|2820275|mysql_secure_installation|2820276|然后启动它。|2820277|mysql+-uroot|2820278|entityMap^0|0|0|0|H|0|0|H|0|0|I|0|0|0|P|0|0|0|C|0^^$0|@$1|2|3|4|5|6|7|X|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Y|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Z|8|@$F|10|G|11|H|I]]|9|@]|A|$]]|$1|J|3|K|5|6|7|12|8|@$F|13|G|14|H|I]]|9|@]|A|$]]|$1|L|3|M|5|6|7|15|8|@$F|16|G|17|H|I]]|9|@]|A|$]]|$1|N|3|O|5|6|7|18|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|19|8|@$F|1A|G|1B|H|I]]|9|@]|A|$]]|$1|R|3|S|5|6|7|1C|8|@]|9|@]|A|$]]|$1|T|3|U|5|6|7|1D|8|@$F|1E|G|1F|H|I]]|9|@]|A|$]]|$1|V|3|-4|5|6|7|1G|8|@]|9|@]|A|$]]]|W|$]]

Homebrew will absolutely never repair the permissions using a standard reinstall, and chasing down which folder/file is corrupted will take longer than it is worth.
In this case - blow away the mysql install manually and reinstall via homebrew. Takes about 2 minutes.
<code>cd /usr/local/var</code>
<code>sudo rm -rf mysql</code>
<code>brew install mysql</code>
Homebrew installs mysql insecure by default, so if you want a password:
<code>mysql_secure_installation</code>
Then fire it up.
<code>mysql -uroot</code>

blocks|key|192912|text|在我的mac+m1+macOS蒙特利上安装了MySQL后，使用brew+install+mysql我得到了以下信息：|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|CODE|entityRanges|data|192913|[System]+[MY-013169]+[Server]+/opt/homebrew/Cellar/mysql/8.0.27_1/bin/mysqld+(mysqld+8.0.27)+initializing+of+server+in+progress+as+process+3624

[ERROR]+[MY-010457]+[Server]+--initialize+specified+but+the+data+directory+has+files+in+it.+Aborting.

[ERROR]+[MY-013236]+[Server]+The+designated+data+directory+/opt/homebrew/var/mysql/+is+unusable.+You+can+remove+all+files+that+the+server+added+to+it.

[ERROR]+[MY-010119]+[Server]+Aborting

[System]+[MY-010910]+[Server]+/opt/homebrew/Cellar/mysql/8.0.27_1/bin/mysqld:+Shutdown+complete+(mysqld+8.0.27)++Homebrew.|code-block|syntax|javascript|192914|还有这条警告：|192915|Warning:+The+post-install+step+did+not+complete+successfully+You+can
try+again+using:+++brew+postinstall+mysql|192916|之后，我尝试使用brew+services+start+mysql启动MySQL，得到以下错误|192917|ERROR+2002+(HY000):+Can't+connect+to+local+MySQL+server+through+socket
'/tmp/mysql.sock'+(2)|192918|我设法用以下命令修复了它：|192919|>+rm+-rf+~/opt/homebrew/var/mysql/
>+brew+postinstall+mysql|192920|现在您可以使用mysql+-uroot或mysql+-uroot+-p进行连接。|192921|entityMap^0|3|F|M|5|V|I|0|0|0|0|8|P|19|2|0|0|0|0|7|C|K|F|0^^$0|@$1|2|3|4|5|6|7|11|8|@$9|12|A|13|B|C]|$9|14|A|15|B|C]|$9|16|A|17|B|D]]|E|@]|F|$]]|$1|G|3|H|5|I|7|18|8|@]|E|@]|F|$J|K]]|$1|L|3|M|5|6|7|19|8|@]|E|@]|F|$]]|$1|N|3|O|5|I|7|1A|8|@]|E|@]|F|$J|K]]|$1|P|3|Q|5|6|7|1B|8|@$9|1C|A|1D|B|D]|$9|1E|A|1F|B|C]]|E|@]|F|$]]|$1|R|3|S|5|I|7|1G|8|@]|E|@]|F|$J|K]]|$1|T|3|U|5|6|7|1H|8|@]|E|@]|F|$]]|$1|V|3|W|5|I|7|1I|8|@]|E|@]|F|$J|K]]|$1|X|3|Y|5|6|7|1J|8|@$9|1K|A|1L|B|D]|$9|1M|A|1N|B|D]]|E|@]|F|$]]|$1|Z|3|-4|5|6|7|1O|8|@]|E|@]|F|$]]]|10|$]]

After installing MySQL on my mac m1 macOS Monterey, using <code>brew install mysql</code> I got this info:
<pre><code>[System] [MY-013169] [Server] /opt/homebrew/Cellar/mysql/8.0.27_1/bin/mysqld (mysqld 8.0.27) initializing of server in progress as process 3624

[ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting.

[ERROR] [MY-013236] [Server] The designated data directory /opt/homebrew/var/mysql/ is unusable. You can remove all files that the server added to it.

[ERROR] [MY-010119] [Server] Aborting

[System] [MY-010910] [Server] /opt/homebrew/Cellar/mysql/8.0.27_1/bin/mysqld: Shutdown complete (mysqld 8.0.27) Homebrew.
</code></pre>
and this warning:
<pre><code>Warning: The post-install step did not complete successfully You can
try again using: brew postinstall mysql
</code></pre>
After that I try to start MySQL using <code>brew services start mysql</code>, and I got this error:
<pre><code>ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
</code></pre>
I managed to fix it using:
<pre><code>&gt; rm -rf ~/opt/homebrew/var/mysql/
&gt; brew postinstall mysql
</code></pre>
Now you can connect with <code>mysql -uroot</code> or <code>mysql -uroot -p</code>.

blocks|key|194912|text|在本地计算机上解决所有这些问题的最佳替代方案->+DOCKER|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|194913|遵循以下步骤，您将与本地mysql安装程序一样好：|194914|194915|安装docker+|ordered-list-item|194916|确保Docker正在运行(只需打开docker桌面应用程序)|194917|在终端上运行此命令->+docker拉取mysql+|194918|运行以下命令，您的mysql已启动并在端口3306上运行，密码为根，用户名也为根|194919|<代码>G211|194920|->+docker运行--名称docker-mysql+-p+3306:3306+-e+MYSQL_ROOT_PASSWORD=root+mysql|194921|entityMap^0|0|V|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|X|8|@$9|Y|A|Z|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|10|8|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|11|8|@]|D|@]|E|$]]|$1|I|3|J|5|K|7|12|8|@]|D|@]|E|$]]|$1|L|3|M|5|K|7|13|8|@]|D|@]|E|$]]|$1|N|3|O|5|K|7|14|8|@]|D|@]|E|$]]|$1|P|3|Q|5|K|7|15|8|@]|D|@]|E|$]]|$1|R|3|S|5|6|7|16|8|@]|D|@]|E|$]]|$1|T|3|U|5|6|7|17|8|@]|D|@]|E|$]]|$1|V|3|-4|5|6|7|18|8|@]|D|@]|E|$]]]|W|$]]

Best Alternative to all these issue on local machine -&gt; DOCKER
Follow this steps and you will be as good as a local mysql setup :
<ol>
<li>Install Docker</li>
<li>Make sure docker is running (Just Open the Docker desktop app)</li>
<li>run this command on terminal -&gt; docker pull mysql</li>
<li>Run the below command and your mysql is up and running on port 3306 with password as root and username also root</li>
</ol>
-&gt; docker run --name docker-mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=root mysql

blocks|key|194282|text|type|unstyled|depth|inlineStyleRanges|entityRanges|data|194283|卸载MySQL。|ordered-list-item|194284|Remove+/usr/local/var/mysql/.|offset|length|style|CODE|194285|Install+|194286|。|194287|194288|entityMap^0|0|0|7|L|0|0|0|0^^$0|@$1|2|3|-4|4|5|6|Q|7|@]|8|@]|9|$]]|$1|A|3|B|4|C|6|R|7|@]|8|@]|9|$]]|$1|D|3|E|4|C|6|S|7|@$F|T|G|U|H|I]]|8|@]|9|$]]|$1|J|3|K|4|C|6|V|7|@]|8|@]|9|$]]|$1|L|3|M|4|C|6|W|7|@]|8|@]|9|$]]|$1|N|3|-4|4|5|6|X|7|@]|8|@]|9|$]]|$1|O|3|-4|4|5|6|Y|7|@]|8|@]|9|$]]]|P|$]]

<ol>
<li>Uninstall MySQL.</li>
<li>Remove <code>/usr/local/var/mysql/</code>.</li>
<li>Install MySQL.</li>
</ol>

I installed MySQL on Mac OS X Mountain Lion with <code>homebrew install mysql</code>, but when I tried <code>mysql -u root</code> I got the following error:

<blockquote>
 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
</blockquote>

What does this error mean? How can I fix it?

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock'

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

我在Mac Lion和homebrew install mysql上安装了MySQL，但当我尝试mysql -u root时，我得到了以下错误：错误2002 (HY000)：无法通过套接字'/tmp/mysql.sock‘连接到本地MySQL服务器(2)这个错误是什么意思？我怎么才能修复它？

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

回答 38

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

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

回答 38

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

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