blocks|key|194905|text|当您让服务器通过|type|unstyled|depth|inlineStyleRanges|entityRanges|data|194906|194907|+mysql.server+start|blockquote|offset|length|style|CODE|194908|194909|194910|您应该会在/tmp/mysql.sock中看到套接字。但是，系统似乎希望它位于/var/mysql/mysql.sock中。要解决此问题，必须在/var/mysql中创建符号链接|194911|194912|+sudo+mkdir+/var/mysql|194913|194914|sudo+ln+-s+/tmp/mysql.sock+/var/mysql/mysql.sock|194915|194916|这为我解决了问题。现在，我的phpMyAdmin可以很好地与本地主机和+127.0.0.1一起工作。|BOLD|194917|功劳归于|194918|entityMap^0|0|0|1|I|0|0|0|0|0|1|L|0|0|0|1C|0|0|Y|1|0|0^^$0|@$1|2|3|4|5|6|7|11|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|12|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|13|8|@$F|14|G|15|H|I]]|9|@]|A|$]]|$1|J|3|-4|5|6|7|16|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|17|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|18|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|19|8|@]|9|@]|A|$]]|$1|O|3|P|5|E|7|1A|8|@$F|1B|G|1C|H|I]]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|1D|8|@]|9|@]|A|$]]|$1|R|3|S|5|6|7|1E|8|@$F|1F|G|1G|H|I]]|9|@]|A|$]]|$1|T|3|-4|5|6|7|1H|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|1I|8|@$F|1J|G|1K|H|W]]|9|@]|A|$]]|$1|X|3|Y|5|6|7|1L|8|@]|9|@]|A|$]]|$1|Z|3|-4|5|6|7|1M|8|@]|9|@]|A|$]]]|10|$]]

When you got the server running via
<blockquote>
<code>mysql.server start</code>
</blockquote>
you should see the socket in /tmp/mysql.sock. However, the system seems to expect it in /var/mysql/mysql.sock. To fix this, you have to create a symlink in /var/mysql:
<blockquote>
<code>sudo mkdir /var/mysql</code>
<code>sudo ln -s /tmp/mysql.sock /var/mysql/mysql.sock</code>
</blockquote>
This solved it for me. Now my phpMyAdmin works happily with localhost and 127.0.0.1.
Credit goes to <a href="http://www.getsymphony.com/discuss/thread/82299/" rel="noreferrer">Henry</a>

blocks|key|197538|text|我在另一个mysql(8.0)安装中留下了一些目录，这些目录没有被删除。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|197539|我通过执行以下操作解决了这个问题：|197540|首先卸载mysql|197541|brew+uninstall+mysql@5.6|code-block|syntax|javascript|197542|删除未删除的文件夹/文件|197543|rm+-rf+/usr/local/var/mysql
rm+/usr/local/etc/my.cnf|197544|重新安装mysql并链接它|197545|brew+install+mysql@5.6
brew+link+--force+mysql@5.6|197546|启用并启动服务|197547|brew+services+start+mysql@5.6|197548|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|6|7|Z|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|10|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|11|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|12|8|@]|9|@]|A|$]]|$1|M|3|N|5|H|7|13|8|@]|9|@]|A|$I|J]]|$1|O|3|P|5|6|7|14|8|@]|9|@]|A|$]]|$1|Q|3|R|5|H|7|15|8|@]|9|@]|A|$I|J]]|$1|S|3|T|5|6|7|16|8|@]|9|@]|A|$]]|$1|U|3|V|5|H|7|17|8|@]|9|@]|A|$I|J]]|$1|W|3|-4|5|6|7|18|8|@]|9|@]|A|$]]]|X|$]]

I had some directories left from another mysql(8.0) installation, that were not removed.

I solved this by doing the following:

First uninstall mysql

<pre><code>brew uninstall mysql@5.6
</code></pre>

Delete the folders/files that were not removed

<pre><code>rm -rf /usr/local/var/mysql
rm /usr/local/etc/my.cnf
</code></pre>

Reinstall mysql and link it

<pre><code>brew install mysql@5.6
brew link --force mysql@5.6
</code></pre>

Enable and start the service

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

blocks|key|199146|text|看起来您的mysql服务器尚未启动。我通常会运行stop命令，然后再次启动它：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|199147|mysqld+stop
mysql.server+start|code-block|syntax|javascript|199148|同样的错误，这也适用于我。|199149|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|2824231|text|尝试使用"127.0.0.1“而不是"localhost”进行连接。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2824232|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|$]]

Try to connect using "127.0.0.1" instead "localhost".

blocks|key|197375|text|当你运行下面的命令时，如果你能看到"mysql已停止“，就执行|type|unstyled|depth|inlineStyleRanges|entityRanges|data|197376|；|ordered-list-item|197377|197378|brew服务列表|197379|197380|，如果你能用下面的命令启动mysql；|197381|197382|mysql服务器启动|197383|这意味着，mysql可以手动启动，但它不会在操作系统启动时自动启动。将mysql添加到服务中可以解决此问题。要这样做，你可以运行下面的命令；|197384|brew+services+start+mysql|code-block|syntax|javascript|197385|在此之后，您可以重新启动操作系统并尝试连接到mysql，以查看它是否会自动启动。我做了同样的事情，并停止接收下面的错误；|197386|197387|错误2002+(HY000)：无法通过套接字'/tmp/mysql.sock‘连接到本地MySQL服务器(2)|blockquote|197388|197389|197390|我希望这能帮到你。|197391|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|16|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|17|8|@]|9|@]|A|$]]|$1|E|3|-4|5|6|7|18|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|19|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|1B|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|1C|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|1D|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|1E|8|@]|9|@]|A|$]]|$1|P|3|Q|5|R|7|1F|8|@]|9|@]|A|$S|T]]|$1|U|3|V|5|6|7|1G|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|1H|8|@]|9|@]|A|$]]|$1|X|3|Y|5|Z|7|1I|8|@]|9|@]|A|$]]|$1|10|3|-4|5|6|7|1J|8|@]|9|@]|A|$]]|$1|11|3|-4|5|6|7|1K|8|@]|9|@]|A|$]]|$1|12|3|13|5|6|7|1L|8|@]|9|@]|A|$]]|$1|14|3|-4|5|6|7|1M|8|@]|9|@]|A|$]]]|15|$]]

<ol>
<li>If you are able to see &quot;mysql stopped&quot; when you run below command;
<pre><code>brew services list
</code></pre>
</li>
<li>and if you are able to start mysql with below command;
<pre><code>mysql server start
</code></pre>
</li>
</ol>
this means; mysql is able to start manually, but it doesn't start automatically when the operating system is started. Adding mysql to services will fix this problem. To do so, you can run below command;
<pre><code>brew services start mysql
</code></pre>
After that, you may restart your operating system and try connecting to mysql to see if it started automatically. I did the same and stop receiving below error;
<blockquote>
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
</blockquote>
I hope this helps.

blocks|key|199382|text|文件/tmp/mysql.sock可能是一个命名管道，因为它在一个临时文件夹中。命名管道是一个永远不会永久存储的特殊文件。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|199383|如果我们创建两个程序，并且我们希望一个程序向另一个程序发送消息，我们可以创建一个文本文件。我们让一个程序在文本文件中写一些东西，另一个程序读我们另一个程序写的东西。这就是管道，除了它不会将文件写入我们的计算机硬盘，IE也不会永久存储文件(就像我们创建文件并保存时一样)。|199384|插座与管道完全相同。不同之处在于，套接字通常是通过网络使用的--在计算机之间。套接字将信息发送到另一台计算机，或从另一台计算机接收信息。管道和套接字都使用临时文件进行共享，以便它们可以“通信”。|199385|很难辨别在这种情况下使用的是哪种MySql。不过这并不重要。|199386|命令mysql.server+start应该让“服务器”(程序)运行它的无限循环，该循环将创建特殊文件并等待更改(用于写入的listen)。|199387|在此之后，一个常见的问题可能是MySql程序没有在您的计算机上创建文件的权限，因此您可能必须为它提供根权限|199388|sudo+mysql.server+start|code-block|syntax|javascript|199389|entityMap^0|2|F|0|0|0|0|2|I|1Q|6|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|6|7|11|8|@]|D|@]|E|$]]|$1|L|3|M|5|6|7|12|8|@$9|13|A|14|B|C]|$9|15|A|16|B|C]]|D|@]|E|$]]|$1|N|3|O|5|6|7|17|8|@]|D|@]|E|$]]|$1|P|3|Q|5|R|7|18|8|@]|D|@]|E|$S|T]]|$1|U|3|-4|5|6|7|19|8|@]|D|@]|E|$]]]|V|$]]

The file <code>/tmp/mysql.sock</code> is probably a Named-Pipe, since it's in a temporary folder. A named pipe is a Special-File that never gets permanently stored. 

If we make two programs, and we want one program to send a message to another program, we could create a text file. We have one program write something in the text file and the other program read what our other program wrote. That's what a pipe is, except it doesn't write the file to our computer hard disk, IE doesn't permanently store the file (like we do when we create a file and save it.)

A Socket is the exact same as a Pipe. The difference is that Sockets are usually used over a network -- between computers. A Socket sends information to another computer, or receives information from another computer. Both Pipes and Sockets use a temporary file to share so that they can 'communicate'.

It's difficult to discern which one MySql is using in this case. Doesn't matter though.

The command <code>mysql.server start</code> should get the 'server' (program) running its infinite loop that will create that special-file and wait for changes (<code>listen</code> for writes).

After that, a common issue might be that the MySql program doesn't have permission to create a file on your machine, so you might have to give it root privileges 

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

blocks|key|2824486|text|在安装macos+mojave后，必须擦除/usr/local/var/mysql下的mysql文件夹，然后通过brew+install+mysql重新安装，否则权限相关的东西会到处都是。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2824487|entityMap^0|L|K|1K|I|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|M|8|@]|D|@]|E|$]]]|G|$]]

After installing macos mojave, had to wipe mysql folder under <code>/usr/local/var/mysql</code> and then reinstall via <code>brew install mysql</code> otherwise permission related things would come up all over the place.

blocks|key|3037226|text|因为我花了相当多的时间来解决这个问题，并且在寻找这个错误时总是返回到这个页面，所以我将把我的解决方案留在这里，希望有人能节省我浪费的时间。虽然在我的例子中，我使用的是mariadb而不是MySql，但您仍然可以根据您的需要调整此解决方案。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3037227|我的问题|3037228|是相同的，但我的设置有点不同(mariadb而不是mysql)：|3037229|安装了mariadb和homebrew|3037230|$+brew+install+mariadb|code-block|syntax|javascript|3037231|已启动守护进程|3037232|$+brew+services+start+mariadb|3037233|尝试连接，但收到上述错误|3037234|$+mysql+-uroot
ERROR+2002+(HY000):+Can't+connect+to+local+MySQL+server+through+socket+'/tmp/mysql.sock'+(2)|3037235|我的解决方案|3037236|找出mysql使用了哪些my.cnf文件(按照此comment中的建议)：|offset|length|style|CODE|3037237|$+mysql+--verbose+--help+%7C+grep+my.cnf
/usr/local/etc/my.cnf+~/.my.cnf
++++++++++++++++++++++++order+of+preference,+my.cnf,+$MYSQL_TCP_PORT,|3037238|检查Unix套接字文件正在运行的位置(几乎与here中描述的一样)：|3037239|$+netstat+-ln+%7C+grep+mariadb
....+/usr/local/mariadb/data/mariadb.sock|3037240|(您可能希望使用grep+mysql而不是mariadb)|3037241|将您找到的套接字文件添加到~/.my.cnf+(如有必要，请创建该文件)(假设从上面运行mysql+--verbose+...-command时列出了~/.my.cnf+)：|3037242|[client]
socket+=+/usr/local/mariadb/data/mariadb.sock|3037243|重新启动mariadb：|3037244|$+brew+services+restart+mariadb|3037245|在此之后，我可以运行mysql并获得：|3037246|$+mysql+-uroot
ERROR+1698+(28000):+Access+denied+for+user+'root'@'localhost'|3037247|因此，我使用超级用户权限运行命令，在输入密码后，我得到：|3037248|$+sudo+mysql+-uroot
MariaDB+[(none)]>|3037249|3037250|备注：|3037251|3037252|我不太确定你必须添加套接字的组，首先我有它的客户端-服务器，但后来我认为客户端应该足够了。所以我更改了它，它仍然有效。|ordered-list-item|3037253|当运行mariadb_config+%7C+grep+socket时，我得到：--socket+[/tmp/mysql.sock]，这有点令人困惑，因为似乎/usr/local/mariadb/data/mariadb.sock是实际的位置(至少在我的机器上)|3037254|我想知道在哪里可以将/usr/local/mariadb/data/mariadb.sock配置为/tmp/mysql.sock，这样我就可以使用默认设置，而不必编辑我的<代码>D28(但我现在太累了，弄不清楚...)<代码>H229<代码>H130在提出这个问题之前，我还做了其他答案中提到的事情。<代码>H231<代码>G232|3037255|3037256|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/10757169/location-of-my-cnf-file-on-macos#comment58805600_10757261|1|https://mariadb.com/kb/en/library/troubleshooting-connection-issues/^0|0|0|0|0|0|0|0|0|0|0|2|5|C|6|O|7|0|0|0|M|4|1|0|0|8|A|0|D|9|18|J|23|9|0|0|0|0|0|0|0|0|0|0|0|0|3|S|11|Q|24|10|0|A|10|1D|F|0|0^^$0|@$1|2|3|4|5|6|7|2C|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|2D|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|2E|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|2F|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|2G|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|2H|8|@]|9|@]|A|$]]|$1|O|3|P|5|J|7|2I|8|@]|9|@]|A|$K|L]]|$1|Q|3|R|5|6|7|2J|8|@]|9|@]|A|$]]|$1|S|3|T|5|J|7|2K|8|@]|9|@]|A|$K|L]]|$1|U|3|V|5|6|7|2L|8|@]|9|@]|A|$]]|$1|W|3|X|5|6|7|2M|8|@$Y|2N|Z|2O|10|11]|$Y|2P|Z|2Q|10|11]]|9|@$Y|2R|Z|2S|1|2T]]|A|$]]|$1|12|3|13|5|J|7|2U|8|@]|9|@]|A|$K|L]]|$1|14|3|15|5|6|7|2V|8|@]|9|@$Y|2W|Z|2X|1|2Y]]|A|$]]|$1|16|3|17|5|J|7|2Z|8|@]|9|@]|A|$K|L]]|$1|18|3|19|5|6|7|30|8|@$Y|31|Z|32|10|11]]|9|@]|A|$]]|$1|1A|3|1B|5|6|7|33|8|@$Y|34|Z|35|10|11]|$Y|36|Z|37|10|11]|$Y|38|Z|39|10|11]]|9|@]|A|$]]|$1|1C|3|1D|5|J|7|3A|8|@]|9|@]|A|$K|L]]|$1|1E|3|1F|5|6|7|3B|8|@]|9|@]|A|$]]|$1|1G|3|1H|5|J|7|3C|8|@]|9|@]|A|$K|L]]|$1|1I|3|1J|5|6|7|3D|8|@]|9|@]|A|$]]|$1|1K|3|1L|5|J|7|3E|8|@]|9|@]|A|$K|L]]|$1|1M|3|1N|5|6|7|3F|8|@]|9|@]|A|$]]|$1|1O|3|1P|5|J|7|3G|8|@]|9|@]|A|$K|L]]|$1|1Q|3|-4|5|6|7|3H|8|@]|9|@]|A|$]]|$1|1R|3|1S|5|6|7|3I|8|@]|9|@]|A|$]]|$1|1T|3|-4|5|6|7|3J|8|@]|9|@]|A|$]]|$1|1U|3|1V|5|1W|7|3K|8|@]|9|@]|A|$]]|$1|1X|3|1Y|5|1W|7|3L|8|@$Y|3M|Z|3N|10|11]|$Y|3O|Z|3P|10|11]|$Y|3Q|Z|3R|10|11]]|9|@]|A|$]]|$1|1Z|3|20|5|1W|7|3S|8|@$Y|3T|Z|3U|10|11]|$Y|3V|Z|3W|10|11]]|9|@]|A|$]]|$1|21|3|-4|5|6|7|3X|8|@]|9|@]|A|$]]|$1|22|3|-4|5|6|7|3Y|8|@]|9|@]|A|$]]]|23|$24|$5|25|26|27|A|$28|29]]|2A|$5|25|26|27|A|$28|2B]]]]

Since I spent quite some time trying to solve this and always came back to this page when looking for this error, I'll leave my solution here hoping that somebody saves the time I've lost. Although in my case I am using mariadb rather than MySql, you might still be able to adapt this solution to your needs.

<h2>My problem</h2>

is the same, but my setup is a bit different (mariadb instead of mysql):

Installed mariadb with homebrew 

<pre><code>$ brew install mariadb
</code></pre>

Started the daemon 

<pre><code>$ brew services start mariadb
</code></pre>

Tried to connect and got the above mentioned error

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

<h2>My solution</h2>

find out which <code>my.cnf</code> files are used by <code>mysql</code> (as suggested in this <a href="https://stackoverflow.com/questions/10757169/location-of-my-cnf-file-on-macos#comment58805600_10757261">comment</a>):

<pre><code>$ mysql --verbose --help | grep my.cnf
/usr/local/etc/my.cnf ~/.my.cnf
 order of preference, my.cnf, $MYSQL_TCP_PORT,
</code></pre>

check where the Unix socket file is running (almost as described <a href="https://mariadb.com/kb/en/library/troubleshooting-connection-issues/" rel="nofollow noreferrer">here</a>):

<pre><code>$ netstat -ln | grep mariadb
.... /usr/local/mariadb/data/mariadb.sock
</code></pre>

(you might want to <code>grep mysql</code> instead of mariadb)

Add the socket file you found to <code>~/.my.cnf</code> (create the file if necessary)(assuming <code>~/.my.cnf</code> was listed when running the <code>mysql --verbose ...</code>-command from above):

<pre><code>[client]
socket = /usr/local/mariadb/data/mariadb.sock
</code></pre>

Restart your mariadb:

<pre><code>$ brew services restart mariadb
</code></pre>

After this I could run mysql and got:

<pre><code>$ mysql -uroot
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
</code></pre>

So I run the command with superuser privileges instead and after entering my password I got:

<pre><code>$ sudo mysql -uroot
MariaDB [(none)]&gt;
</code></pre>

<hr>

Notes:

<ol>
<li>I'm not quite sure about the groups where you have to add the socket, first I had it [client-server] but then I figured [client] should be enough. So I changed it and it still works.</li>
<li>When running <code>mariadb_config | grep socket</code> I get:
<code>--socket [/tmp/mysql.sock]</code>
which is a bit confusing since it seems that <code>/usr/local/mariadb/data/mariadb.sock</code> is the actual place (at least on my machine)</li>
<li>I wonder where I can configure the <code>/usr/local/mariadb/data/mariadb.sock</code> to actually be <code>/tmp/mysql.sock</code>so I can use the default settings instead of having to edit my <code>.my.cnf</code> (but I'm too tired now to figure that out...)</li>
<li>At some point I also did things mentioned in other answers before coming up with this.</li>
</ol>

blocks|key|197364|text|我得到了同样的错误，这对我有帮助：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|197365|$ln+-sfv+/usr/local/opt/mysql/*.plist+~/Library/LaunchAgents
$launchctl+load+~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
$mysql+-uroot
mysql>|code-block|syntax|javascript|197366|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|$]]

I got the same error and this is what helped me:

<pre><code>$ln -sfv /usr/local/opt/mysql/*.plist ~/Library/LaunchAgents
$launchctl load ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
$mysql -uroot
mysql&gt;
</code></pre>

blocks|key|199284|text|我在我的mac上遇到了同样的问题，并通过遵循以下教程解决了它|type|unstyled|depth|inlineStyleRanges|entityRanges|data|199285|https://mariadb.com/resources/blog/installing-mariadb-10116-mac-os-x-homebrew|offset|length|199286|但在继续之前，不要忘记删除或卸载旧版本。|199287|命令：|199288|brew+uninstall+mariadb

xcode-select+--install

ruby+-e+"$(curl+-fsSL+https://raw.githubusercontent.com/Homebrew/install/master/install)"+-+See+more+at:+https://mariadb.com/resources/blog/installing-mariadb-10116-mac-os-x-homebrew#sthash.XQoxRoJp.dpuf

brew+doctor

brew+update

brew+info+mariadb

brew+install+mariadb

mysql_install_db

mysql.server+start|code-block|syntax|javascript|199289|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|25|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|W|8|@]|9|@$D|X|E|Y|1|Z]]|A|$]]|$1|F|3|G|5|6|7|10|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|11|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|12|8|@]|9|@]|A|$M|N]]|$1|O|3|-4|5|6|7|13|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|C]]]]

I faced the same problem on my mac and solved it, by following the following tutorials

<a href="https://mariadb.com/resources/blog/installing-mariadb-10116-mac-os-x-homebrew" rel="nofollow noreferrer">https://mariadb.com/resources/blog/installing-mariadb-10116-mac-os-x-homebrew</a>

But don't forget to kill or uninstall the old version before continuing.

Commands:

<pre><code>brew uninstall mariadb

xcode-select --install

ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)" - See more at: https://mariadb.com/resources/blog/installing-mariadb-10116-mac-os-x-homebrew#sthash.XQoxRoJp.dpuf

brew doctor

brew update

brew info mariadb

brew install mariadb

mysql_install_db

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

blocks|key|2824426|text|为了补充这些答案，在我的例子中，我没有本地mySQL服务器，它在docker容器中运行。因此套接字文件不存在，"mysql“客户端将无法访问。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2824427|该sock文件由mysqld创建，mysql使用该文件与其通信。但是，如果您的mySql服务器未在本地运行，则不需要sock文件。|2824428|通过指定主机名/ip，不需要sock文件，例如|2824429|mysql+--host=127.0.0.1+--port=3306+--user=xyz+--password=xyz|code-block|syntax|javascript|2824430|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|O|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|P|8|@]|9|@]|A|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Just to add to these answers, In my case I had no local mySQL server, it was running inside a docker container. So the socket file does not exist and will not be accessible for the "mysql" client.

The sock file gets created by mysqld and mysql uses this to communicate with it.
However if your mySql server is not running local, it does not require the sock file.

By specifying a host name/ip the sock file is not required e.g. 

<pre><code>mysql --host=127.0.0.1 --port=3306 --user=xyz --password=xyz
</code></pre>

blocks|key|3037706|text|如果"mysqld“正在运行，那么您的数据可能已损坏。尝试运行以下命令：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3037707|mysqld|code-block|syntax|javascript|3037708|通过数据墙读取，并检查mysqld是否报告数据库已损坏。损坏可能以许多非直观的方式出现：|3037709|3037710|mysql+-uroot返回“错误2002+(HY000)：无法通过套接字连接到本地MySQL服务器”/tmp/mysql.sock‘socket返回“错误！服务器退出而没有更新PID”。|unordered-list-item|offset|length|style|CODE|3037711|Sequel+Pro和MySQL工作台响应它们无法连接到本地主机或127.0.0.1上的MySQL。|3037712|3037713|要恢复数据，请打开my.cnf并在[mysqld]部分中添加以下行：|3037714|innodb_force_recovery=1|3037715|重启mysqld：|3037716|$+brew+services+restart+mysql@5.6|3037717|现在您可以连接到它，但它处于受限只读模式。|3037718|如果您使用的是InnoDB，请运行以下命令导出所有数据：|3037719|$+mysqldump+-u+root+-p+--all-databases+--add-drop-database+--add-drop-table+>+data-recovery.sql|3037720|该文件在您的~+dir中创建。这可能需要一些时间。|3037721|完成后，从my.cnf中移除innodb_force_recovery=1，然后以正常模式重启mysql：|3037722|$+brew+services+restart+mysql@5.6|3037723|删除所有数据库。我是用Sequel+Pro做的。这会删除所有原始数据。在执行此操作之前，请确保您的数据恢复.sql看起来很好。另外，考虑备份/usr/local/var/mysql时要格外小心。|BOLD|3037724|然后使用以下命令恢复数据库、表和数据：|3037725|$+mysql+-uroot+<+~/data-recovery.sql|3037726|这可能是一个很长的导入/恢复过程。一旦完成，你就可以开始工作了！|3037727|感谢访问https://severalnines.com/database-blog/my-mysql-database-corrupted-what-do-i-do-now获取恢复说明。该链接包含有关MyISAM恢复的更多说明。|3037728|entityMap|0|LINK|mutability|MUTABLE|url|https://severalnines.com/database-blog/my-mysql-database-corrupted-what-do-i-do-now^0|0|0|0|0|0|C|0|0|0|H|8|0|0|0|0|0|0|0|0|E|N|0|0|O|B|1Y|K|0|0|0|0|4|2B|0|0^^$0|@$1|2|3|4|5|6|7|1W|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|1X|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|1Y|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|1Z|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|20|8|@$M|21|N|22|O|P]]|9|@]|A|$]]|$1|Q|3|R|5|L|7|23|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|24|8|@]|9|@]|A|$]]|$1|T|3|U|5|6|7|25|8|@$M|26|N|27|O|P]]|9|@]|A|$]]|$1|V|3|W|5|D|7|28|8|@]|9|@]|A|$E|F]]|$1|X|3|Y|5|6|7|29|8|@]|9|@]|A|$]]|$1|Z|3|10|5|D|7|2A|8|@]|9|@]|A|$E|F]]|$1|11|3|12|5|6|7|2B|8|@]|9|@]|A|$]]|$1|13|3|14|5|6|7|2C|8|@]|9|@]|A|$]]|$1|15|3|16|5|D|7|2D|8|@]|9|@]|A|$E|F]]|$1|17|3|18|5|6|7|2E|8|@]|9|@]|A|$]]|$1|19|3|1A|5|6|7|2F|8|@$M|2G|N|2H|O|P]]|9|@]|A|$]]|$1|1B|3|1C|5|D|7|2I|8|@]|9|@]|A|$E|F]]|$1|1D|3|1E|5|6|7|2J|8|@$M|2K|N|2L|O|1F]|$M|2M|N|2N|O|P]]|9|@]|A|$]]|$1|1G|3|1H|5|6|7|2O|8|@]|9|@]|A|$]]|$1|1I|3|1J|5|D|7|2P|8|@]|9|@]|A|$E|F]]|$1|1K|3|1L|5|6|7|2Q|8|@]|9|@]|A|$]]|$1|1M|3|1N|5|6|7|2R|8|@]|9|@$M|2S|N|2T|1|2U]]|A|$]]|$1|1O|3|-4|5|6|7|2V|8|@]|9|@]|A|$]]]|1P|$1Q|$5|1R|1S|1T|A|$1U|1V]]]]

If &quot;mysqld&quot; IS running, it's possible your data is corrupted. Try running this:
<pre><code>mysqld
</code></pre>
Read through the wall of data, and check if mysqld is reporting that the database is corrupted. Corruption can present in many unintuitive ways:
<ul>
<li><code>mysql -uroot</code> returns &quot;ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)&quot;.</li>
<li><code>mysql.server start</code> returns &quot;ERROR! The server quit without updating PID&quot;.</li>
<li>Sequel Pro and MySQL Workbench responds that they can't connect to MySQL on localhost or 127.0.0.1.</li>
</ul>
To recover your data, open my.cnf and add the following line in the <code>[mysqld]</code> section:
<pre><code>innodb_force_recovery=1
</code></pre>
Restart mysqld:
<pre><code>$ brew services restart mysql@5.6
</code></pre>
Now you can connect to it, but it’s in limited read-only mode.
If you're using InnoDB, run this to export all your data:
<pre><code>$ mysqldump -u root -p --all-databases --add-drop-database --add-drop-table &gt; data-recovery.sql
</code></pre>
The file is created in your ~ dir. It may take some time.
Once finished, remove <code>innodb_force_recovery=1</code> from my.cnf, then restart mysql in normal mode:
<pre><code>$ brew services restart mysql@5.6
</code></pre>
Drop all the databases. I did this using Sequel Pro. This deletes all your original data. Make sure your data-recovery.sql looks good before doing this. Also consider backing up <code>/usr/local/var/mysql</code> to be extra careful.
Then restore the databases, tables, and data with this:
<pre><code>$ mysql -uroot &lt; ~/data-recovery.sql
</code></pre>
This can be a long import/restoration process. Once complete, you’re good to go!
Thanks go to <a href="https://severalnines.com/database-blog/my-mysql-database-corrupted-what-do-i-do-now" rel="nofollow noreferrer">https://severalnines.com/database-blog/my-mysql-database-corrupted-what-do-i-do-now</a> for the recovery instructions. The link has further instructions on MyISAM recovery.

blocks|key|2824395|text|你需要运行mysql_install_db+-最简单的方法是如果你在安装目录中：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2824396|$+cd+/usr/local/Cellar/mysql/<version>/+
$+mysql_install_db|code-block|syntax|javascript|2824397|或者，您可以向mysql_install_db提供如下所示的basedir参数：|2824398|$+mysql_install_db+--basedir="$(brew+--prefix+mysql)"|2824399|entityMap^0|5|G|0|0|7|G|U|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|H|7|Z|8|@]|D|@]|E|$I|J]]|$1|O|3|-4|5|6|7|10|8|@]|D|@]|E|$]]]|P|$]]

You'll need to run <code>mysql_install_db</code> - easiest way is if you're in the install directory: 

<pre><code>$ cd /usr/local/Cellar/mysql/&lt;version&gt;/ 
$ mysql_install_db
</code></pre>

Alternatively, you can feed <code>mysql_install_db</code> a <code>basedir</code> parameter like the following:

<pre><code>$ mysql_install_db --basedir="$(brew --prefix mysql)"
</code></pre>

blocks|key|2824637|text|重新启动后，我无法连接到本地mariadb，搜索也将我带到此页面，我想与您分享我的解决方案。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2824638|我注意到/usr/local/etc/中缺少my.cnf.d目录。|2824639|这是一个已知的bug，描述并在那里解决了它。https://github.com/Homebrew/homebrew-core/issues/36801|offset|length|2824640|快速修复方法:+mkdir+/usr/local/etc/my.cnf.d|2824641|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/Homebrew/homebrew-core/issues/36801^0|0|0|M|1I|0|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|@$F|U|G|V|1|W]]|A|$]]|$1|H|3|I|5|6|7|X|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q]]]]

After a restart I could not connect with the local mariadb, a search also brought me to this page and I wanted to share my solution with you.

I noticed that the directory my.cnf.d in /usr/local/etc/ is missing. 

This is a known bug with homebrew that is described and solved there. <a href="https://github.com/Homebrew/homebrew-core/issues/36801" rel="nofollow noreferrer">https://github.com/Homebrew/homebrew-core/issues/36801</a>

fast way to fix: mkdir /usr/local/etc/my.cnf.d

blocks|key|3037563|text|在我的例子中，罪魁祸首是在日志文件中找到的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3037564|$+tail+/usr/local/var/mysql/<hostname>.lan.err
2019-09-19++7:32:21+0+[ERROR]+InnoDB:+redo+log+file+'./ib_logfile0'+exists.+Creating+system+tablespace+with+existing+redo+log+files+is+not+recommended.+Please+delete+all+redo+log+files+before+creating+new+system+tablespace.
2019-09-19++7:32:21+0+[ERROR]+InnoDB:+Database+creation+was+aborted+with+error+Generic+error.+You+may+need+to+delete+the+ibdata1+file+before+trying+to+start+up+again.|code-block|syntax|javascript|3037565|因此，我重命名了ib_logfile0以消除这个错误(后来我不得不对ib_logfile1执行同样的操作)。|offset|length|style|CODE|3037566|mv+/usr/local/var/mysql/ib_logfile0+/usr/local/var/mysql/ib_logfile0_bak
mv+/usr/local/var/mysql/ib_logfile1+/usr/local/var/mysql/ib_logfile1_bak
brew+services+restart+mariadb|3037567|entityMap^0|0|0|8|B|Y|B|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|@$I|T|J|U|K|L]|$I|V|J|W|K|L]]|9|@]|A|$]]|$1|M|3|N|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|O|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|P|$]]

In my case, the culprit was found in the logfiles:

<pre><code>$ tail /usr/local/var/mysql/&lt;hostname&gt;.lan.err
2019-09-19 7:32:21 0 [ERROR] InnoDB: redo log file './ib_logfile0' exists. Creating system tablespace with existing redo log files is not recommended. Please delete all redo log files before creating new system tablespace.
2019-09-19 7:32:21 0 [ERROR] InnoDB: Database creation was aborted with error Generic error. You may need to delete the ibdata1 file before trying to start up again.
</code></pre>

So I renamed <code>ib_logfile0</code> to get rid of the error (I had to do the same with <code>ib_logfile1</code> afterwards).

<pre><code>mv /usr/local/var/mysql/ib_logfile0 /usr/local/var/mysql/ib_logfile0_bak
mv /usr/local/var/mysql/ib_logfile1 /usr/local/var/mysql/ib_logfile1_bak
brew services restart mariadb
</code></pre>

blocks|key|2824696|text|当运行mysql_secure_installation并输入新密码时，我得到：|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2824697|2824698|2824699|错误:无法通过套接字'/tmp/mysql.sock‘(2)连接到本地MySQL服务器|blockquote|2824700|2824701|2824702|2824703|在this+answer中尝试执行以下命令时，我注意到了|2824704|2824705|+netstat+-ln+%7C+grep+mysql|2824706|2824707|2824708|它没有返回任何内容，我认为这意味着没有.sock文件。|2824709|因此，我将以下内容添加到我的my.cnf文件中(在/etc/my.cnf中或在我的示例中为/usr/local/etc/my.cnf).|2824710|在以下位置：|2824711|[mysqld]
socket=/tmp/mysql.sock|code-block|syntax|javascript|2824712|2824713|[client]
socket=/tmp/mysql.sock|2824714|这是基于this+post的。|2824715|然后再次停止/启动mysql，并重试mysql_secure_installation，最终让我输入新的根密码并继续其他设置首选项。|2824716|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/15016376/cant-connect-to-local-mysql-server-through-socket-homebrew/50478351#50478351|1|https://discourse.brew.sh/t/for-homebrew-mysql-installs-how-to-fix-mysql-sock-path/660^0|3|P|0|0|0|0|0|0|0|1|B|0|0|0|0|0|0|0|E|6|P|B|19|L|0|0|0|0|0|4|9|1|0|I|P|0^^$0|@$1|2|3|4|5|6|7|1M|8|@$9|1N|A|1O|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|1P|8|@]|D|@]|E|$]]|$1|G|3|-4|5|6|7|1Q|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|1R|8|@]|D|@]|E|$]]|$1|K|3|-4|5|6|7|1S|8|@]|D|@]|E|$]]|$1|L|3|-4|5|6|7|1T|8|@]|D|@]|E|$]]|$1|M|3|-4|5|6|7|1U|8|@]|D|@]|E|$]]|$1|N|3|O|5|6|7|1V|8|@]|D|@$9|1W|A|1X|1|1Y]]|E|$]]|$1|P|3|-4|5|6|7|1Z|8|@]|D|@]|E|$]]|$1|Q|3|R|5|J|7|20|8|@]|D|@]|E|$]]|$1|S|3|-4|5|6|7|21|8|@]|D|@]|E|$]]|$1|T|3|-4|5|6|7|22|8|@]|D|@]|E|$]]|$1|U|3|V|5|6|7|23|8|@]|D|@]|E|$]]|$1|W|3|X|5|6|7|24|8|@$9|25|A|26|B|C]|$9|27|A|28|B|C]|$9|29|A|2A|B|C]]|D|@]|E|$]]|$1|Y|3|Z|5|6|7|2B|8|@]|D|@]|E|$]]|$1|10|3|11|5|12|7|2C|8|@]|D|@]|E|$13|14]]|$1|15|3|Z|5|6|7|2D|8|@]|D|@]|E|$]]|$1|16|3|17|5|12|7|2E|8|@]|D|@]|E|$13|14]]|$1|18|3|19|5|6|7|2F|8|@]|D|@$9|2G|A|2H|1|2I]]|E|$]]|$1|1A|3|1B|5|6|7|2J|8|@$9|2K|A|2L|B|C]]|D|@]|E|$]]|$1|1C|3|-4|5|6|7|2M|8|@]|D|@]|E|$]]]|1D|$1E|$5|1F|1G|1H|E|$1I|1J]]|1K|$5|1F|1G|1H|E|$1I|1L]]]]

When running mysql_secure_installation and entering the new password I got:
<hr />
<blockquote>
Error: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
</blockquote>
<hr />
I noticed when trying the following from <a href="https://stackoverflow.com/questions/15016376/cant-connect-to-local-mysql-server-through-socket-homebrew/50478351#50478351">this answer</a>:
<blockquote>
<pre><code>netstat -ln | grep mysql
</code></pre>
</blockquote>
It didn't return anything, and I took that to mean that there wasn't a .sock file.
So, I added the following to my my.cnf file (either in /etc/my.cnf or in my case, /usr/local/etc/my.cnf).
Under:
<pre><code>[mysqld]
socket=/tmp/mysql.sock
</code></pre>
Under:
<pre><code>[client]
socket=/tmp/mysql.sock
</code></pre>
This was based on <a href="https://discourse.brew.sh/t/for-homebrew-mysql-installs-how-to-fix-mysql-sock-path/660" rel="nofollow noreferrer">this post</a>.
Then stop/start mysql again and retried mysql_secure_installation which finally let me enter my new root password and continue with other setup preferences.

blocks|key|2824956|text|如果brew没有完成“安装后”，我只需使用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2824957|sudo+chown+-R+$(whoami)+/usr/local/*|code-block|syntax|javascript|2824958|然后通过以下方式完成安装后配置：|2824959|brew+postinstall+mysql@5.7|2824960|下一步只需启动mysql@5.7服务。|2824961|我在MacOS蒙特利的时候用得很好。|2824962|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|$]]

If brew does not complete &quot;postinstall&quot;
I only have to use:
<pre><code>sudo chown -R $(whoami) /usr/local/*
</code></pre>
then completed postinstall by:
<pre><code>brew postinstall mysql@5.7
</code></pre>
next step just start mysql@5.7 service.
It worked for me on MacOS Monterey.

blocks|key|197412|text|来完成这个线程。因此，MAMP+(PRO)经常被使用|type|unstyled|depth|inlineStyleRanges|entityRanges|data|197413|这里的路径是|197414|/Applications/MAMP/tmp/mysql/mysql.sock|code-block|syntax|javascript|197415|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

just to complete this thread.
therefore MAMP (PRO) is used pretty often

the path here is

<pre><code>/Applications/MAMP/tmp/mysql/mysql.sock
</code></pre>

blocks|key|199422|text|我在系统偏好设置窗格中手动启动了mysql，方法是初始化数据库，然后启动它。这解决了我的问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|199423|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 manually started mysql in the system preferences pane by initialising the database and then starting it. This solved my problem.

blocks|key|197649|text|我也有同样的问题。在尝试了所有这些方法都没有成功之后，我做了以下操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|197650|tail+-f+the-mysql-or-maria-db-error-file.err|code-block|syntax|javascript|197651|在另一个控制台中：|197652|brew+services+restart+mariadb|197653|我看到以下错误：|197654|197655|+"MAC+HOMEBREW崩溃恢复失败。请更正问题(例如，内存不足错误)并重新启动，或者删除tc日志并使用“|blockquote|197656|197657|197658|所以我将tc.log扩展名改为tc.log.txt并重启mariadb|offset|length|style|CODE|197659|brew+services+restart+mariadb|197660|完成了！|197661|entityMap^0|0|0|0|0|0|0|0|0|0|4|6|F|A|0|0|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|15|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|16|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|17|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|18|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|19|8|@]|9|@]|A|$]]|$1|N|3|O|5|P|7|1A|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|1B|8|@]|9|@]|A|$]]|$1|R|3|-4|5|6|7|1C|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|1D|8|@$U|1E|V|1F|W|X]|$U|1G|V|1H|W|X]]|9|@]|A|$]]|$1|Y|3|Z|5|D|7|1I|8|@]|9|@]|A|$E|F]]|$1|10|3|11|5|6|7|1J|8|@]|9|@]|A|$]]|$1|12|3|-4|5|6|7|1K|8|@]|9|@]|A|$]]]|13|$]]

I had same problem. After trying all these methods without success I did the following: 

<pre><code>tail -f the-mysql-or-maria-db-error-file.err
</code></pre>

in another console:

<pre><code>brew services restart mariadb
</code></pre>

I saw the following error: 

<blockquote>
 "MAC HOMEBREW Crash recovery failed. Either correct the problem (if
 it's, for example, out of memory error) and restart, or delete tc log
 and start mysqld with"
</blockquote>

So I changed the <code>tc.log</code> extesion to <code>tc.log.txt</code> and restart mariadb 

<pre><code>brew services restart mariadb
</code></pre>

and done!

blocks|key|197018|text|LINUX|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|197019|虽然答案应该只针对MacOS，但在Linux中我们可能会遇到同样的错误。|197020|我在Linux上也面临着同样的问题。我运行了这个命令：|197021|sudo+/etc/init.d/mysql.server+start|code-block|syntax|javascript|197022|我能够运行MySQL服务器|197023|参考https://gist.github.com/vinodpandey/1a4b5b8228f9a000ca236820185fc3bc|197024|entityMap|0|LINK|mutability|MUTABLE|url|https://gist.github.com/vinodpandey/1a4b5b8228f9a000ca236820185fc3bc^0|0|5|0|0|0|0|0|2|1W|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@$9|11|A|12|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|13|8|@]|D|@]|E|$]]|$1|H|3|I|5|6|7|14|8|@]|D|@]|E|$]]|$1|J|3|K|5|L|7|15|8|@]|D|@]|E|$M|N]]|$1|O|3|P|5|6|7|16|8|@]|D|@]|E|$]]|$1|Q|3|R|5|6|7|17|8|@]|D|@$9|18|A|19|1|1A]]|E|$]]|$1|S|3|-4|5|6|7|1B|8|@]|D|@]|E|$]]]|T|$U|$5|V|W|X|E|$Y|Z]]]]

[LINUX]
Though answer is expected to be for MacOS only but in Linux we may face the same Error.
I was facing the same issue in Linux. I ran this command:
<pre><code>sudo /etc/init.d/mysql.server start
</code></pre>
and I was able to run the MySQL server
Ref. <a href="https://gist.github.com/vinodpandey/1a4b5b8228f9a000ca236820185fc3bc" rel="nofollow noreferrer">https://gist.github.com/vinodpandey/1a4b5b8228f9a000ca236820185fc3bc</a>

blocks|key|3037599|text|这对我来说很有效：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3037600|brew+upgrade+mysql|code-block|syntax|javascript|3037601|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 works for me:
<pre><code>brew upgrade mysql
</code></pre>

blocks|key|195188|text|对我来说，我很久以前就安装了mariadb，然后又安装了mysql@5.7。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|195189|当我执行mysql+-uroot时，我得到了错误：ERROR+2002+(HY000):+Can't+connect+to+local+MySQL+server+through+socket+'/tmp/mysql.sock'+(2)|195190|阅读答案：|195191|我从文件夹/usr/local/var/mysql|195192|Ran+mariadb|unordered-list-item|195193|
|195194|Deleted+mysqld+--initialize|195195|
卸载了|195196|195197|195198|然后我就可以mysql+-uroot+-p了|195199|entityMap^0|E|7|S|9|0|4|C|P|2K|0|0|5|K|0|4|7|0|0|8|J|0|0|0|0|6|F|0^^$0|@$1|2|3|4|5|6|7|10|8|@$9|11|A|12|B|C]|$9|13|A|14|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|15|8|@$9|16|A|17|B|C]|$9|18|A|19|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|1A|8|@]|D|@]|E|$]]|$1|J|3|K|5|6|7|1B|8|@$9|1C|A|1D|B|C]]|D|@]|E|$]]|$1|L|3|M|5|N|7|1E|8|@$9|1F|A|1G|B|C]]|D|@]|E|$]]|$1|O|3|P|5|6|7|1H|8|@]|D|@]|E|$]]|$1|Q|3|R|5|N|7|1I|8|@$9|1J|A|1K|B|C]]|D|@]|E|$]]|$1|S|3|T|5|6|7|1L|8|@]|D|@]|E|$]]|$1|U|3|-4|5|N|7|1M|8|@]|D|@]|E|$]]|$1|V|3|-4|5|6|7|1N|8|@]|D|@]|E|$]]|$1|W|3|X|5|6|7|1O|8|@$9|1P|A|1Q|B|C]]|D|@]|E|$]]|$1|Y|3|-4|5|6|7|1R|8|@]|D|@]|E|$]]]|Z|$]]

For me, I had installed <code>mariadb</code> long time ago, then installed <code>mysql@5.7</code>.
When I executed <code>mysql -uroot</code>, I get the error:
<code>ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)</code>
Reading the answers:
<ul>
<li>I uninstalled <code>mariadb</code></li>
<li>Deleted the folder <code>/usr/local/var/mysql</code></li>
<li>Ran the command <code>mysqld --initialize</code></li>
</ul>
Then I was able to <code>mysql -uroot -p</code>

I recently tried installing MySQL with homebrew (<code>brew install mysql</code>) and when I try to run it I get the following error:

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

There is no <code>/tmp/mysql.sock</code> nor a <code>/var/lib/mysql.sock</code>.

I've searched and haven't found any <code>mysql.sock</code> file.

How can I fix this?

Can't connect to local MySQL server through socket homebrew

日志文件

数据恢复

数据库

服务器

MariaDB

容器

Docker

MySQL

Linux

MacOS

Unix

我最近尝试使用homebrew (brew install mysql)安装MySQL，当我尝试运行它时，我得到了以下错误：错误2002 (HY000)：无法通过套接字'/tmp/mysql.sock‘连接到本地MySQL服务器(2)既没有/tmp/mysql.sock也没有/var/lib/mysql.sock。我已经搜索过了，但没有找到任何mysql.sock文件。我该如何解决这个问题呢？

问无法通过套接字自制软件连接到本地MySQL服务器
EN

回答 23

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问无法通过套接字自制软件连接到本地MySQL服务器EN

回答 23

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问无法通过套接字自制软件连接到本地MySQL服务器
EN