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

Question

我在苹果电脑上重新安装了MySQL服务器和工作台，因为我忘记了密码。我成功地这样做了；但是，我收到这条消息，说我无法连接到服务器。

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

并尝试再次连接