mysqld_safe fatal error : Can't remove the pid file

Question

尝试运行命令/usr/local/mysql/bin/mysqld_safe 时出现此错误:

    mysqld_safe Logging to '/usr/local/mysql/data/Users-MacBook-Pro.local.err'.
    cat: /usr/local/mysql/data/Users-MacBook-Pro.local.pid: Permission denied
    rm: cannot remove ‘/usr/local/mysql/data/Users-MacBook-Pro.local.pid’: 
    Permission   denied
    140313 11:09:18 mysqld_safe Fatal error: Can't remove the pid file:
    /usr/local/mysql/data/Users-MacBook-Pro.local.pid
    Please remove it manually and start /usr/local/mysql/bin/mysqld_safe again;
    mysqld daemon not started
    /usr/local/mysql/bin/mysqld_safe: line 129: 
    /usr/local/mysql/data/Users-MacBook-   Pro.local.err: Permission denied

我应该删除文件吗？移除它是否安全？

Answer 1

删除这个 pid 文件，确保所有实例都已停止(杀死所有未关闭的进程)，检查没有任何东西正在监听 MySQL 端口 3306(netstat 应该有帮助)并尝试再次启动 MySQL。
要解决此问题，请查看您的用户对需要存储 pid 的文件夹的权限!