MAMP 的 PHPMyAdmin 给我 #2002 mysql 错误

发布于 2024-12-02 22:38:37 字数 811 浏览 2 评论 0原文

因此，只有当我转到本地 PhpMyAdmin 窗口时，我才会收到 #2002 消息。我搜索了网络，发现了一个终端命令来检查 Mysql 是否会首先运行，而且确实如此。

运行 /Applications/MAMP/Library/bin/mysql -u root -p

给我

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.5.9 Source distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.

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.

这看起来不错，我认为所以错误一定与此没有太大关系。

我读到，在 config.inc.php 文件中，您将值“localhost”替换为“127.0.0.1”，但这并没有改变情况。

然后我去 MYSQL 论坛查找，建议检查 my.cnf 文件以检查某些值。但我到处都找不到它。 MAMP 中是否有另一个具有相同功能的文件？

原文

So only when I go to my local PhpMyAdmin window, I get the #2002 message.
I searched the net and I found a terminal command to check if Mysql would be running in the first place and it does.

Running /Applications/MAMP/Library/bin/mysql -u root -p

gives me

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.5.9 Source distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.

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.

That doesn't look bad I think so the error must not have much to do with that.

I read that there's the config.inc.php file where you replace the value 'localhost' with '127.0.0.1' but that didn't change the situation.

Then I went looking in MYSQL forums it is suggested to check the my.cnf file to check for certain values. but I can't find it anywhere. Is there another file that has the same function in MAMP?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

想念有你 2024-12-09 22:38:37

由于得票最高的答案托管在 Posterous 上，而 Posterous 已不复存在，因此这有点孤儿。内容为已在 Archive.org 存档，但以防万一也消失，链接的答案是：

今天，我尝试使用 SQL Packager 在 OS X Lion 上安装 Mysql。我遇到了非常常见的问题：
MySQL 论坛 :: 安装 :: 错误 2002 (HY000): 无法通过套接字 '/tmp/mysql.sock' 连接到本地 MySQL 服务器 (2)
事实证明，您可以使用以下命令在终端中重新生成此文件：
ps -e|grep mysqld
sudo mysqld_safe
感谢 David Bocage 的提示。