osx下brew install mysql之后mysql报错的问题

最新推荐文章于 2025-06-29 23:52:58 发布

原创最新推荐文章于 2025-06-29 23:52:58 发布 · 1.4w 阅读

1 ·

CC 4.0 BY-SA版权

本文记录了一次解决Mac环境下MySQL无法启动的问题经历，包括错误信息解析、尝试不同启动方式及最终解决方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

报错如下：

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

然后查看/tmp/目录下根本没有mysql.sock

其实当年安装完brew install mysql之后，还要这样：

brew info mysql来进行配置

用他们推荐的mysql.server start无法启动，报错：

junjiedeMacBook-Pro:mysql junjielin$ mysql.server start

Starting MySQL

..................................................................................................... ERROR! The server quit without updating PID file (/usr/local/var/mysql/junjiedeMacBook-Pro.local.pid).

但是突然发现用这种方式可以：

junjiedeMacBook-Pro:mysql junjielin$ mysql -uroot -h127.0.0.1 -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 1

Server version: 5.6.19 Homebrew

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>

这是怎么回事？

后来重启电脑之后正常了！

Last login: Fri Jun 13 18:36:35 on console

junjiedeMacBook-Pro:~ junjielin$ ps -ef|grep mysql

501 349 343 0 6:40下午 ttys000 0:00.00 grep mysql

junjiedeMacBook-Pro:~ junjielin$ mysqlmysql -uroot -h127.0.0.1 -p

-bash: mysqlmysql: command not found

junjiedeMacBook-Pro:~ junjielin$ mysql -uroot -h127.0.0.1 -p

Enter password:

ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)

junjiedeMacBook-Pro:~ junjielin$ mysql.server start

Starting MySQL

. SUCCESS!

junjiedeMacBook-Pro:~ junjielin$ ps -ef|grep mysql

501 363 1 0 6:41下午 ttys000 0:00.02 /bin/sh /usr/local/Cellar/mysql/5.6.19/bin/mysqld_safe --datadir=/usr/local/var/mysql --pid-file=/usr/local/var/mysql/junjiedeMacBook-Pro.local.pid

501 459 363 0 6:41下午 ttys000 0:00.41 /usr/local/Cellar/mysql/5.6.19/bin/mysqld --basedir=/usr/local/Cellar/mysql/5.6.19 --datadir=/usr/local/var/mysql --plugin-dir=/usr/local/Cellar/mysql/5.6.19/lib/plugin --log-error=/usr/local/var/mysql/junjiedeMacBook-Pro.local.err --pid-file=/usr/local/var/mysql/junjiedeMacBook-Pro.local.pid

501 461 343 0 6:41下午 ttys000 0:00.00 grep mysql

junjiedeMacBook-Pro:~ junjielin$ mysql