mysql - XAMPP MySQL InnoDB 错误

Question

我知道这不是一个编程问题，但我正在尝试开始开发。

我在使用 Mac 版 MySQL XAMPP 时遇到很多问题。 (OS X El Capitan 版本 10.11.6)

这是我的错误日志:

2017-06-22 08:53:05 642 mysqld_safe mysqld from pid file /Applications/XAMPP/xamppfiles/var/mysql/Han.local.pid ended

2017-06-23 08:59:06 757 mysqld_safe Starting mysqld daemon with databases from /Applications/XAMPP/xamppfiles/var/mysql Warning: World-writable config file '/Applications/XAMPP/xamppfiles/etc/my.cnf' is ignored

2017-06-23 8:59:07 140735271018496 [Note] /Applications/XAMPP/xamppfiles/sbin/mysqld (mysqld 10.1.22-MariaDB) starting as process 828 ...

2017-06-23 8:59:07 140735271018496 [Warning] Setting lower_case_table_names=2 because file system for /Applications/XAMPP/xamppfiles/var/mysql/ is case insensitive

2017-06-23 8:59:07 140735271018496 [Note] InnoDB: Using mutexes to ref count buffer pool pages

2017-06-23 8:59:07 140735271018496 [Note] InnoDB: The InnoDB memory heap is disabled

2017-06-23 8:59:07 140735271018496 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2017-06-23 8:59:07 140735271018496 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier

2017-06-23 8:59:07 140735271018496 [Note] InnoDB: Compressed tables use zlib 1.2.8

2017-06-23 8:59:07 140735271018496 [Note] InnoDB: Using SSE crc32 instructions

2017-06-23 8:59:07 140735271018496 [ERROR] mysqld: Can't create/write to file '/var/folders/gt/pwvyl66n6_g9q2q76tbbzkyw0000gn/T/ibbELXWV' (Errcode: 13 "Permission denied")

2017-06-23 08:59:07 7fff7bd62000 InnoDB: Error: unable to create temporary file; errno: 13

2017-06-23 8:59:07 140735271018496 [ERROR] Plugin 'InnoDB' init function returned error.

2017-06-23 8:59:07 140735271018496 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

2017-06-23 8:59:07 140735271018496 [Note] Plugin 'FEEDBACK' is disabled.

2017-06-23 8:59:07 140735271018496 [ERROR] Unknown/unsupported storage engine: InnoDB

2017-06-23 8:59:07 140735271018496 [ERROR] Aborting

2017-06-23 08:59:07 757 mysqld_safe mysqld from pid file /Applications/XAMPP/xamppfiles/var/mysql/Han.local.pid ended

这是我尝试过的:

• 使用 Terminal Sodu 更改文件夹的所有权限。
• 使用终端重新启动 MySQL。
• 卸载 XAMPP
• 卸载并删除 XAMPP 文件夹
• 更改存储引擎
• 将端口 3306 更改为 3307

我不知道还能尝试什么，我已经束手无策了。

拜托，如果有其他人和我遇到同样的问题并且能够解决它，请告诉我!

压力头痛开始了! D:

Answer 1

好吧，我设法找到了解决方案:打开终端并输入:

sudo /Applications/XAMPP/xampfiles/xampp fix_rights

此外，my.cnf 不喜欢设置为所有权限，因此将其设置为 600。

希望这可以帮助其他人解决问题。