mysql - 无法运行MySQL服务器

Question

我在 MACOS 上使用 XAMPP

这是我的日志文件

2018-03-11  0:07:24 140735825187776 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2018-03-11  0:07:24 140735825187776 [Note] InnoDB: Compressed tables use zlib 1.2.8
2018-03-11  0:07:24 140735825187776 [Note] InnoDB: Using generic crc32 instructions
2018-03-11  0:07:24 140735825187776 [ERROR] mysqld: Can't create/write to file '/var/folders/6h/0k9bd25j1kl4v_381tm0vykh0000gn/T/ibfDLofU' (Errcode: 13 "Permission denied")
2018-03-11 00:07:24 7fff9cde13c0  InnoDB: Error: unable to create temporary file; errno: 13
2018-03-11  0:07:24 140735825187776 [ERROR] Plugin 'InnoDB' init function returned error.
2018-03-11  0:07:24 140735825187776 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2018-03-11  0:07:24 140735825187776 [Note] Plugin 'FEEDBACK' is disabled.
2018-03-11  0:07:24 140735825187776 [ERROR] Unknown/unsupported storage engine: InnoDB
2018-03-11  0:07:24 140735825187776 [ERROR] Aborting

2018-03-11 00:07:24 4813 mysqld_safe mysqld from pid file /Applications/XAMPP/xamppfiles/var/mysql/Hovhanness-iMac.local.pid ended

谢谢!

Answer 1

您的日志是自动解释的:

所以首先尝试在这里解决权限问题:

2018-03-11  0:07:24 140735825187776 [ERROR] mysqld: 
Can't create/write to file '/var/folders/6h/0k9bd25j1kl4v_381tm0vykh0000gn/T/ibfDLofU' (Errcode: 13 "Permission denied")

为此(以及其他类似的使用谷歌)即

[ERROR] Unknown/unsupported storage engine: InnoDB

使用谷歌我看到了这个: https://serverfault.com/questions/379714/unknown-unsupported-storage-engine-innodb-mysql-ubuntu

检查下一个...

等等