MySQL - 由于忘记密码而重新安装，但无法连接到服务器(Mac OS)

Question

我在 Mac 上重新安装了 MySQL Server 和 Workbench，因为我忘记了密码。我成功做到了；但是，我收到一条消息，说我无法连接到服务器。

2018-10-21 17:10:13 - Starting server...
2018-10-21 17:10:13 - Executing 'launchctl load -F/Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist'
2018-10-21 17:10:18 - Checking server status...
2018-10-21 17:10:18 - Trying to connect to MySQL...
2018-10-21 17:10:18 - Can't connect to MySQL server on '127.0.0.1' (61) (2003)
2018-10-21 17:10:18 - Assuming server is not running
2018-10-21 17:10:18 - Starting server...
2018-10-21 17:10:18 - Executing 'launchctl load -F /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist'
2018-10-21 17:10:18 - Start server: /Library/LaunchDaemons/com.oracle.oss.my
2018-10-21 17:10:18 - Start server: sql.mysqld.plist: service already loaded

2018-10-21 17:10:18 - Server start done.
2018-10-21 17:10:22 - Checking server status...
2018-10-21 17:10:22 - Trying to connect to MySQL...
2018-10-21 17:10:22 - Can't connect to MySQL server on '127.0.0.1' (61) (2003)
2018-10-21 17:10:22 - Assuming server is not running

谁能告诉我如何解决这个问题？谢谢。

Answer 1

检查mysql是否启动并运行:

ps -aux | grep mysql

如果不是，请使用命令

mysql.server start

或者尝试重新启动服务

mysql.server restart

并尝试再次连接