自动生成临时密码后无法访问MySQL
我已经删除并安装了OSX 10.11 El Capitan并且我一直在通过本教程学习如何在新的OS X上运行MySQL 。第一步是下载MySQL For Mac OS X 10.9(x86,64位),DMG归档 (10.11版本,他们在教程中推荐)。 当我完成MySQL的安装时,我收到了这样的消息:
2015-10-25T02:10:54.549219Z 1 [Note] A temporary password is generated for root@localhost: R>gFySuiu23U If you lose this password, please consult the section How to Reset the Root Password in the MySQL reference manual.
这很奇怪,我从来没有见过这样的信息。 之后,我通过Preference Pane启动MySQL,然后在terminal上使用/usr/local/mysql/bin/mysql -v命令进行另一步。 我收到一条错误消息,说:
ERROR 1045 (28000): Access denied for user 'cheetah'@'localhost' (using password: NO)
我也尝试通过Sequel Pro使用root作为用户名和空密码访问数据库,我得到了访问被拒绝的消息,说:
Unable to connect to host 127.0.0.1 because access was denied. Double-check your username and password and ensure that access from your current location is permitted. MySQL said: Access denied for user 'root'@'localhost' (using password: NO)
好的,我也使用root作为用户名,但是使用了'R> gFySuiu23U'作为密码(它是从MySQL生成的)。 我有连接失败的消息说:
Unable to connect to host 127.0.0.1, or the request timed out. Be sure that the address is corr