首页 / MYSQL / mamp mysql无法启动
mamp mysql无法启动
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了mamp mysql无法启动,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含3217字,纯文字阅读大概需要5分钟。
内容图文
![mamp mysql无法启动](/upload/InfoBanner/zyjiaocheng/909/6542870ec324483795b18722ec90fdb9.jpg)
我有mysql服务器的问题.当我启动MAMP时,Mysql服务器无法启动.我试图改变端口,但它没有帮助.我检查错误日志,我发现这个:
161010 09:21:07 mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysql56
2016-10-10 09:21:07 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-10-10 09:21:07 0 [Note] /Applications/MAMP/Library/bin/mysqld (mysqld 5.6.28) starting as process 6633 ...
2016-10-10 09:21:07 6633 [Warning] Setting lower_case_table_names=2 because file system for /Applications/MAMP/db/mysql56/ is case insensitive
2016-10-10 09:21:07 6633 [Note] Plugin 'FEDERATED' is disabled.
/Applications/MAMP/Library/bin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13 - Permission denied)
2016-10-10 09:21:07 6633 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2016-10-10 09:21:07 6633 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-10-10 09:21:07 6633 [Note] InnoDB: The InnoDB memory heap is disabled
2016-10-10 09:21:07 6633 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-10-10 09:21:07 6633 [Note] InnoDB: Memory barrier is not used
2016-10-10 09:21:07 6633 [Note] InnoDB: Compressed tables use zlib 1.2.8
2016-10-10 09:21:07 6633 [Note] InnoDB: Using CPU crc32 instructions
2016-10-10 09:21:07 6633 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-10-10 09:21:07 6633 [Note] InnoDB: Completed initialization of buffer pool
2016-10-10 09:21:07 6633 [Note] InnoDB: Highest supported file format is Barracuda.
2016-10-10 09:21:07 6633 [Note] InnoDB: 128 rollback segment(s) are active.
2016-10-10 09:21:07 6633 [Note] InnoDB: Waiting for purge to start
2016-10-10 09:21:07 6633 [Note] InnoDB: 5.6.28 started; log sequence number 1600617
2016-10-10 09:21:07 6633 [Note] RSA private key file not found: /Applications/MAMP/db/mysql56//private_key.pem. Some authentication plugins will not work.
2016-10-10 09:21:07 6633 [Note] RSA public key file not found: /Applications/MAMP/db/mysql56//public_key.pem. Some authentication plugins will not work.
2016-10-10 09:21:07 6633 [Note] Server hostname (bind-address): '*'; port: 3308
2016-10-10 09:21:07 6633 [Note] IPv6 is available.
2016-10-10 09:21:07 6633 [Note] - '::' resolves to '::';
2016-10-10 09:21:07 6633 [Note] Server socket created on IP: '::'.
2016-10-10 09:21:07 6633 [ERROR] /Applications/MAMP/Library/bin/mysqld: Can't find file: './mysql/user.frm' (errno: 13 - Permission denied)
2016-10-10 09:21:07 6633 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/user.frm' (errno: 13 - Permission denied)
161010 09:21:07 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended
我希望有人可以帮我解决这个问题.
解决方法:
我不知道这是不是你的问题,但是我试着用killall -9 mysqld杀??死mysqld并尝试在Activity Monitor中运行mysqld,但它并不存在.
最终我把它解决了:在我遇到问题之前发生的事情是mysqldump被打断了.这破坏了表空间.所以我退出并重新启动MAMP PRO(服务器未设置为自动启动).然后使用MAMPs文件>更改了my.cnf编辑模板.并添加了行innodb_force_recovery = 1.之后服务器启动正常.修复后我注释掉了这一行.
内容总结
以上是互联网集市为您收集整理的mamp mysql无法启动全部内容,希望文章能够帮你解决mamp mysql无法启动所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。