MySQL : sudo mysqld_safe --skip-grant-tables & hangs

Question

我不小心删除了所有 mysql 用户，因此无法访问任何数据库。

我正在使用 http://www.kevssite.com/2011/07/02/deleted-rootlocalhost-account-in-mysql/链接以再次重新创建根用户帐户。

但问题是每当我发出命令 sudo mysqld_safe --skip-grant-tables & 我的脚本永远挂起。因此，我无法按照上面给出的链接中提到的后续步骤进行操作。

 mysqld_safe Can't log to error log and syslog at the same time.  Remove all --log-error configuration options for --syslog to take effect.
151130 18:17:51 mysqld_safe Logging to '/var/log/mysql/error.log'.
151130 18:17:51 mysqld_safe A mysqld process already exists

Answer 1

确保在运行 mysqld_safe 之前先杀死 mysqld:

killall mysqld mysqld_safe
# give it 10 seconds or so to shut down cleanly
ps aux | grep mysqld
# if you still see mysqld, more violent action might be needed,
# but it might
# corrupt your data. But if it a test or empty install, no problem
killall -9 mysqld mysqld_safe
# now mysqld_safe should start 

您还应该从 my.cnf 中删除 syslog 或 log-error 以解决来自 mysqld_safe.