MAMP 的 PHPMyAdmin 给我 #2002 mysql 错误 [英] PHPMyAdmin of MAMP giving me #2002 mysql error
问题描述
因此,只有当我转到本地 PhpMyAdmin 窗口时,才会收到 #2002 消息.我在网上搜索,我找到了一个终端命令来检查 Mysql 是否会首先运行,并且确实如此.
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.
运行 /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.
我认为这看起来不错,所以错误一定与此无关.
That doesn't look bad I think so the error must not have much to do with that.
我读到在 config.inc.php 文件中,您将值 'localhost' 替换为 '127.0.0.1' 但这并没有改变情况.
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.
然后我在 MYSQL 论坛中寻找建议检查 my.cnf 文件以检查某些值.但我在任何地方都找不到.MAMP中是否有其他文件具有相同的功能?
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?
推荐答案
由于最高投票的答案托管在已不存在的 Posterous 上,因此这有点孤儿.内容是存档在 Archive.org 但以防万一 也消失了,链接的答案是:
Since the top-voted answer was hosted on Posterous, which no longer exists, this is a bit of an orphan. The content is archived at Archive.org but just in case that goes away, too, the linked answer was:
今天,我尝试使用 SQL Packager 在 OS X Lion 上安装 Mysql.我遇到了 很常见的问题:
Today, I tried to install Mysql on OS X Lion using SQL Packager. I faced a very common issue:
MySQL 论坛 :: 安装 :: ERROR 2002 (HY000):无法通过套接字/tmp/mysql.sock"连接到本地 MySQL 服务器 (2)
事实证明你可以在终端中重新生成这个文件:
Turns out you can regenerate this file in the terminal with this:
ps -e|grep mysqld
sudo mysqld_safe
感谢 David Bocage 的提示.
这篇关于MAMP 的 PHPMyAdmin 给我 #2002 mysql 错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!