我已经使用MAMP了很长一段时间,但几个月前它开始给我带来问题.我已经通过谷歌搜索和堆栈溢出在线查找解决方案,但我还没有看到任何可以帮助我的东西.
我已经搜索了一些文章,但我觉得这些文章已经接近帮助我了:
MAMP mysql没有启动 我不确定我的数据目录的路径?我在终端输入的任何东西似乎都回来了,因为没有找到
Mysql服务无法启动,InnoDB初始化函数错误
MAMP mysql服务器无法启动.没有运行mysql进程 我试图killall但是"没有找到属于你的匹配进程"错误
大约一个小时前我的mqsql工作但不是apache,所以我发现文章说要将Library/bin/envvars重命名为_envvars,apache在启动时工作,但后来mysql没有.
我的php日志中没有出现任何错误,但这是我的apache和mysql日志.
这是mysql错误日志底部的一个片段
InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 35 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 35 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 35 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 35 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 35 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 35 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 35 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 35 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 35 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 35 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 35 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 35 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. 170118 15:52:39 InnoDB: Unable to open the first data file InnoDB: Error in opening ./ibdata1 170118 15:52:39 InnoDB: Operating system error number 35 in a file operation. InnoDB: Error number 35 means 'Resource temporarily unavailable'. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html 170118 15:52:39 InnoDB: Could not open or create data files. 170118 15:52:39 InnoDB: If you tried to add new data files, and it failed here, 170118 15:52:39 InnoDB: you should now edit innodb_data_file_path in my.cnf back 170118 15:52:39 InnoDB: to what it was, and remove the new ibdata files InnoDB created 170118 15:52:39 InnoDB: in this failed attempt. InnoDB only wrote those files full of 170118 15:52:39 InnoDB: zeros, but did not yet use them in any way. But be careful: do not 170118 15:52:39 InnoDB: remove old data files which contain your precious data! 170118 15:52:39 [ERROR] Plugin 'InnoDB' init function returned error. 170118 15:52:39 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 170118 15:52:39 [ERROR] Unknown/unsupported storage engine: InnoDB 170118 15:52:39 [ERROR] Aborting 170118 15:52:39 [Note] /Applications/MAMP/Library/bin/mysqld: Shutdown complete 170118 15:52:39 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended
然后是apache错误日志
[Wed Jan 18 15:48:28 2017] [notice] Digest: generating secret for digest authentication ... [Wed Jan 18 15:48:28 2017] [notice] Digest: done [Wed Jan 18 15:48:28 2017] [notice] Apache/2.2.17 (Unix) mod_ssl/2.2.17 OpenSSL/0.9.8zh DAV/2 PHP/5.3.6 configured -- resuming normal operations [Wed Jan 18 15:48:31 2017] [notice] caught SIGTERM, shutting down [Wed Jan 18 15:51:01 2017] [notice] Digest: generating secret for digest authentication ... [Wed Jan 18 15:51:01 2017] [notice] Digest: done [Wed Jan 18 15:51:01 2017] [notice] Apache/2.2.17 (Unix) mod_ssl/2.2.17 OpenSSL/0.9.8zh DAV/2 PHP/5.3.6 configured -- resuming normal operations
我的端口是:apache 80和mysql 3306.
如果有人可能知道可能会发生什么,这将是惊人的..