mysql错误！安装brew时，服务器退出而不更新PID文件

Question

我输入了以下命令：

ps -ef | grep mysql
  501 78808     1   0 11:45AM ??         0:00.03 /bin/sh /usr/local/opt/mysql/bin/mysqld_safe --bind-address=127.0.0.1 --datadir=/usr/local/var/mysql
  501 78904 78808   0 11:45AM ??         0:00.51 /usr/local/Cellar/mysql/5.7.17/bin/mysqld --basedir=/usr/local/Cellar/mysql/5.7.17 --datadir=/usr/local/var/mysql --plugin-dir=/usr/local/Cellar/mysql/5.7.17/lib/plugin --bind-address=127.0.0.1 --log-error=/usr/local/var/mysql/DrewJocham.err --pid-file=/usr/local/var/mysql/DrewJocham.pid
  501 79182 31676   0 11:49AM ttys006    0:00.00 grep mysql

我试着brew uninstall mysql，然后brew install mysql，我甚至试着去网站下载它，但是不能启动。我不知道发生了什么。这一切都是突然发生的。

在brew install mysql之后

DrewJocham:~ DrewJocham$ brew install mysql
==> Downloading https://homebrew.bintray.com/bottles/mysql-5.7.17.sierra.bottle.tar.gz
Already downloaded: /Users/DrewJocham/Library/Caches/Homebrew/mysql-5.7.17.sierra.bottle.tar.gz
==> Pouring mysql-5.7.17.sierra.bottle.tar.gz
==> Using the sandbox
==> Caveats
We've installed your MySQL database without a root password. To secure it run:
    mysql_secure_installation

To connect run:
    mysql -uroot

To have launchd start mysql now and restart at login:
  brew services start mysql
Or, if you don't want/need a background service you can just run:
  mysql.server start
==> Summary
?  /usr/local/Cellar/mysql/5.7.17: 14,226 files, 444.4M

这是我试图在终端上停止并重新启动mysql：

DrewJocham:~ DrewJocham$ mysql.server stop
Shutting down MySQL
.. SUCCESS! 
DrewJocham:~ DrewJocham$ mysql.server start
Starting MySQL
 SUCCESS! 
DrewJocham:~ DrewJocham$ usage: grep [-abcDEFGHhIiJLlmnOoqRSsUVvwxZ] [-A num] [-B num] [-C[num]]
    [-e pattern] [-f file] [--binary-files=value] [--color=when]
    [--context[=num]] [--directories=action] [--label] [--line-buffered]
    [--null] [pattern] [file ...]
2017-01-16T16:53:14.6NZ mysqld_safe A mysqld process already exists

任何建议都将不胜感激。

Answer 1

尝试使用sudo来启动、重新启动或停止它！我以前也遇到过同样的问题。另一件对你有帮助的事情是：

在MacOS中重新安装Mysql的链接：

https://coderwall.com/p/os6woq/uninstall-all-those-broken-versions-of-mysql-and-re-install-it-with-brew-on-mac-mavericks

https://blog.joefallon.net/2013/10/install-mysql-on-mac-osx-using-homebrew/

链接如果您在登录时遇到任何问题：

MySQL ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using password: YES)

读一读吧，谁知道它能帮到你。

:)