blocks|key|3331697|text|回答你问题的第一部分：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3331698|跑|3331699|%25+mysqladmin+-p+-u+<user-name>+variables|code-block|syntax|javascript|3331700|并检查“socket”变量|3331701|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|F|7|O|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

to answer the first part of your question:

run 

<pre><code>% mysqladmin -p -u &lt;user-name&gt; variables
</code></pre>

and check the 'socket' variable

blocks|key|3119035|text|这解决了我的问题|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3119036|mysql_config+--socket|code-block|syntax|javascript|3119037|更新|offset|length|style|BOLD|3119038|mysql_config可以告诉我们文件mysql.sock应该在哪里，但在我的例子中，这个文件并不存在。所以，我删除了my.cnf：|3119039|sudo+rm+-rf+/etc/my.cnf|3119040|然后重启mysql：|3119041|brew+services+restart+mysql|3119042|文件已创建，mysql现在运行良好。|3119043|entityMap^0|0|0|0|2|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|@$I|11|J|12|K|L]]|9|@]|A|$]]|$1|M|3|N|5|6|7|13|8|@]|9|@]|A|$]]|$1|O|3|P|5|D|7|14|8|@]|9|@]|A|$E|F]]|$1|Q|3|R|5|6|7|15|8|@]|9|@]|A|$]]|$1|S|3|T|5|D|7|16|8|@]|9|@]|A|$E|F]]|$1|U|3|V|5|6|7|17|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|18|8|@]|9|@]|A|$]]]|X|$]]

This solved my problem 

<pre><code>mysql_config --socket
</code></pre>

UPDATE

mysql_config can tell us where the file mysql.sock should be, but in my case the file didn't exist. So, I've deleted my.cnf:

<pre><code>sudo rm -rf /etc/my.cnf
</code></pre>

And then restarted mysql:

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

The file was created and mysql is now running well.

blocks|key|344539|text|这为我找到了它：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|344540|netstat+-ln+%7C+grep+mysql|code-block|syntax|javascript|344541|Mac+OSX|344542|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|$]]

This found it for me:

<pre><code>netstat -ln | grep mysql
</code></pre>

Mac OSX

blocks|key|343091|text|套接字文件应在MySQL守护程序启动时自动创建。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|343092|如果没有找到它，很可能是应该包含它的目录不存在，或者其他一些文件系统问题阻止了套接字的创建。|343093|要找出文件应该在哪里，请使用：|343094|%25+mysqld+--verbose+--help+%7C+grep+%5Esocket|code-block|syntax|javascript|343095|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|$]]

The socket file should be created automatically when the MySQL daemon starts.

If it isn't found, most likely the directory which is supposed to contain it doesn't exist, or some other file system problem is preventing the socket from being created.

To find out where the file should be, use:

<pre><code>% mysqld --verbose --help | grep ^socket
</code></pre>

blocks|key|3119024|text|我的问题也是mysql.sock-file。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3119025|在drupal安装过程中，我不得不说出我想使用哪个数据库，但是没有找到我的数据库|3119026|mkdir+/var/mysql
ln+-s+/tmp/mysql.sock+/var/mysql/mysql.sock|code-block|syntax|javascript|3119027|系统正在搜索mysql.sock，但它在错误的目录中|3119028|您所要做的就是链接它;)|3119029|我花了很多时间在谷歌上搜索所有重要的信息，但我甚至花了几个小时才找到如何适应，但现在我可以给出结果了:D|3119030|ps:如果你想做到这一点，你必须将你的/tmp/mysql.sock-file+(如果它也位于你的系统中)链接到由php.ini+(或php.default.ini)给出的目录，其中pdo_mysql.default_socket=+...|offset|length|style|CODE|3119031|entityMap^0|0|0|0|0|0|0|J|K|2J|T|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|6|7|11|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|12|8|@$Q|13|R|14|S|T]|$Q|15|R|16|S|T]]|9|@]|A|$]]|$1|U|3|-4|5|6|7|17|8|@]|9|@]|A|$]]]|V|$]]

My problem was also the mysql.sock-file.

During the drupal installation process, i had to say which database i want to use
but my database wasn't found 

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

the system is searching mysql.sock but it's in the wrong directory

all you have to do is to link it ;)

it took me a lot of time to google all important informations but it took me even hours to find out how to adapt , but now i can present the result :D

ps: if you want to be exactly you have to link your <code>/tmp/mysql.sock-file</code> (if it is located in your system there too) to the directory given by the php.ini (or php.default.ini) where <code>pdo_mysql.default_socket= ...</code>

blocks|key|3119109|text|我使用以下命令获得了确切的路径：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3119110|netstat+-ln+%7C+grep+-o+-m+1+-E+'\S*mysqld?\.sock'|code-block|syntax|javascript|3119111|因为这只返回路径，不需要任何输入，所以您可以在shell脚本中使用它。|3119112|MySQL当前必须在您的计算机上运行，才能正常工作。也适用于MariaDB。|3119113|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|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

I got the exact path using:

<pre><code>netstat -ln | grep -o -m 1 -E '\S*mysqld?\.sock'
</code></pre>

Since this only returns the path and doesn't require any input you could potentially use it in a shell script.

MySQL must be currently running on your machine for this to work. Works for MariaDB too.

blocks|key|3119085|text|最初的问题似乎来自于对a)文件在哪里，以及b)它在哪里被查找(以及为什么我们在执行定位或grep时找不到它)的困惑。我认为Alnitak的观点是你想要找到它链接的位置--但是grep不会给你显示一个链接，对吧？文件不在那里，因为它是一个链接，它只是一个指针。您仍然需要知道将链接放在哪里。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3119086|我的sock文件肯定在/tmp中，我得到的错误是在/var/lib/+(不仅仅是/var)中查找它，我现在已经链接到/var和/var/lib，但我仍然得到错误“无法通过套接字'var/lib/mysql.sock‘(2)连接到本地MySQL服务器”。|3119087|注意错误后的(2)+....我在另一个线程上发现，这意味着可能确实有人试图使用套接字，但套接字本身有问题-所以要完全关闭机器-所以套接字关闭。那么重启应该可以修复它。我试过了，但它对我不起作用(现在我怀疑我是否重启得太快了？真的吗？)也许这将是另一个人的解决方案。|3119088|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

The original questions seems to come from confusion about a) where is the file, and b) where is it being looked for (and why can't we find it there when we do a locate or grep). I think Alnitak's point was that you want to find where it was linked to - but grep will not show you a link, right? The file doesn't live there, since it's a link it is just a pointer. You still need to know where to put the link. 

my sock file is definitely in /tmp and the ERROR I am getting is looking for it in /var/lib/ (not just /var) I have linked to /var and /var/lib now, and I still am getting the error "Cannot connect to local MySQL server through socket 'var/lib/mysql.sock' (2)". 

Note the (2) after the error.... I found on another thread that this means the socket might be indeed attempted to be used, but something is wrong with the socket itself - so to shut down the machine - completely - so that the socket closes. Then a restart should fix it. I tried this, but it didn't work for me (now I question if I restarted too quickly? really?) Maybe it will be a solution for someone else.

blocks|key|343109|text|$+mysqladmin+variables+%7C+grep+sock|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|343110|尝试这样做，这将输出所需的结果，删除不相关的信息。|unstyled|343111|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>$ mysqladmin variables | grep sock
</code></pre>

Try this instead, this will output the demanded result, getting rid of unrelated info.

blocks|key|3119170|text|我在Mac+OS+X+10.11.6上遇到了同样的错误：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3119171|ERROR+2002+(HY000):+Can't+connect+to+local+MySQL+server+through+socket+'/tmp/mysql.sock'+(2)|offset|length|style|CODE|3119172|我在这里和相关的问题中苦苦钻研了很多建议，但似乎都没能解决这个问题，于是我回去删除了安装的文件夹，然后就做了brew+install+mysql。|3119173|大多数命令仍然会出现相同的错误，但这是可行的：|3119174|/usr/local/bin/mysqld|3119175|并返回：|3119176|3119177|：为连接做好准备。|blockquote|3119178|3119179|版本：'5.7.12‘套接字：'/tmp/mysql.sock’端口:3306Homebrew|3119180|entityMap^0|0|0|2K|0|1I|I|0|0|0|L|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|@$D|10|E|11|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|12|8|@$D|13|E|14|F|G]]|9|@]|A|$]]|$1|J|3|K|5|6|7|15|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|16|8|@$D|17|E|18|F|G]]|9|@]|A|$]]|$1|N|3|O|5|6|7|19|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]|$1|Q|3|R|5|S|7|1B|8|@]|9|@]|A|$]]|$1|T|3|-4|5|6|7|1C|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|1D|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|1E|8|@]|9|@]|A|$]]]|X|$]]

I'm getting the same error on Mac OS X 10.11.6:
<code>ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)</code>
After a lot of agonizing and digging through advice here and in related questions, none of which seemed to fix the problem, I went back and deleted the installed folders, and just did <code>brew install mysql</code>.
Still getting the same error with most commands, but this works:
<code>/usr/local/bin/mysqld</code>
and returns:
<blockquote>
/usr/local/bin/mysqld: ready for connections.
Version: '5.7.12' socket: '/tmp/mysql.sock' port: 3306 Homebrew
</blockquote>

blocks|key|3331703|text|为了刷新locate的数据库，我运行了|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3331704|/usr/libexec/locate.updatedb|code-block|syntax|javascript|3331705|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|$]]

To refresh the locate's database I ran

<pre><code>/usr/libexec/locate.updatedb
</code></pre>

blocks|key|3331848|text|我根本找不到mysql套接字，所以重装了mysql服务器(所有的表和phpmyadmin设置都被保留了下来)。以下是命令：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3331849|1)安装|3331850|3331851|+sudo+apt-get+install+mysql-server|blockquote|3331852|3331853|3331854|2)按照终端配置步骤操作|3331855|3331856|+sudo+mysql_secure_installation|3331857|3331858|3331859|3)查看状态：(返回"+active+:+active+(running)")|3331860|3331861|+systemctl+status+mysql.service|3331862|3331863|entityMap^0|0|0|0|0|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|-4|5|6|7|10|8|@]|9|@]|A|$]]|$1|E|3|F|5|G|7|11|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|12|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|13|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|14|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|15|8|@]|9|@]|A|$]]|$1|M|3|N|5|G|7|16|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|17|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|18|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|19|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]|$1|T|3|U|5|G|7|1B|8|@]|9|@]|A|$]]|$1|V|3|-4|5|6|7|1C|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|1D|8|@]|9|@]|A|$]]]|X|$]]

I couldn't find mysql socket at all so reinstalled mysql server(all tables and phpmyadmin settings were preserved). Here are the commands: 

1) Install

<blockquote>
 sudo apt-get install mysql-server
</blockquote>

2) Follow terminal configuration steps

<blockquote>
 sudo mysql_secure_installation
</blockquote>

3) Check status: (Should return "Active: active (running)")

<blockquote>
 systemctl status mysql.service
</blockquote>

blocks|key|3331870|text|不幸的是，上述方法在我的情况下都不起作用。但最终我找到了解决方案。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3331871|要查找mysql.sock文件的位置，只需打开xampp管理器，选择MySQL，然后单击右侧的Configure。在配置面板上，单击Open+Conf+File，只需按CMD%2BF快捷键即可搜索mysql.sock。|3331872|在我的示例中，管理员的所有者被更改了，我必须使用chmod+root:admin+mysql.sock将其更改回root+admin|3331873|在此之后，数据库已被访问。|3331874|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

Unfortunately none of the above have worked in my case. But finally I found solutions.

To find where is mysql.sock file, simply open xampp manager, select MySQL and click on Configure on the right. On the config panel click Open Conf File, and simply search for mysql.sock by pressing the CMD+F shortcut.

In my case, the owner of the mysql.sock was changed, and I had to change it back to root admin with: chmod root:admin mysql.sock

After that the database had been accessed.

blocks|key|348145|text|我无法回答问题#1，但是要刷新locate的文件数据库，可以运行以下命令：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|348146|updatedb|code-block|syntax|javascript|348147|entityMap^0|F|6|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

I can't help with question #1, but to refresh <code>locate</code>'s file database, run:

<pre><code>updatedb
</code></pre>

I just had to re-install mysql and I am having a problem starting it up. It cannot find the socket (mysql.sock). The problem is that neither can I. In my Mac OS X 10.4 terminal, I type: <code>locate mysql.sock</code>, and I get back <code>/private/tmp/mysql.sock</code>. It makes sense that the socket file exist in that location, but it actually does not.

<ol>
<li>How can I find the socket file?</li>
<li>If locate is returning a false location, it must have some sort of memory and probably indexes. How can I refresh that index?</li>
</ol>

Cannot find mysql.sock

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

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

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

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

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

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

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云AI代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

功能1上新10个字符

功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符。

功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符。

功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符

功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符

功能4上新

文章&问答评论现已支持表情

全新交互，全新视觉，新增快捷键、悬浮工具栏、高亮块等功能并同时优化现有功能，全面提升创作效率和体验

社区富文本编辑器全新改版！诚邀体验～ 

精选全网热门MCP server，让你的AI更好用 🚀

💥开发者 MCP广场重磅上线！

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我刚刚重新安装了mysql，启动时遇到了问题。它找不到套接字(mysql.sock)。问题是我也不能。在我的MacOSX10.4终端上，我输入：locate mysql.sock，然后返回/private/tmp/mysql.sock。套接字文件存在于该位置是有意义的，但实际上并不存在。如何找到套接字文件？如果locate返回错误的位置，则它必须具有某种类型的内存和可能的索引。如何刷新索引？

问找不到mysql.sock
EN

回答 13

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问找不到mysql.sockEN

回答 13

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问找不到mysql.sock
EN