我正在尝试用XAMPP设置一个MySQL服务器,它不工作,并且我得到了这个错误:
2014-10-28 14:14:38 3768 [Note] Plugin 'FEDERATED' is disabled.
2014-10-28 14:14:38 588 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This
option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2014-10-28 14:14:38 3768 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-10-28 14:14:38 3768 [Note] InnoDB: The InnoDB memory heap is disabled
2014-10-28 14:14:38 3768 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-10-28 14:14:38 3768 [Note] InnoDB: Memory barrier is not used
2014-10-28 14:14:38 3768 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-10-28 14:14:38 3768 [Note] InnoDB: Not using CPU crc32 instructions
2014-10-28 14:14:38 3768 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-10-28 14:14:38 3768 [Note] InnoDB: Completed initialization of buffer pool
2014-10-28 14:14:38 3768 [ERROR] InnoDB: C:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2014-10-28 14:14:38 3768 [ERROR] InnoDB: The system tablespace must be writable!
2014-10-28 14:14:38 3768 [ERROR] Plugin 'InnoDB' init function returned error.
2014-10-28 14:14:38 3768 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2014-10-28 14:14:38 3768 [ERROR] Unknown/unsupported storage engine: InnoDB
2014-10-28 14:14:38 3768 [ERROR] Aborting
摘自mysql.log
我确实尝试了重新安装,使用AppleWS,以及我在这里找到的一些修复程序。它们都不起作用。
发布于 2014-10-29 03:55:43
下面这几行:
2014-10-28 14:14:38 3768 [ERROR] InnoDB: C:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2014-10-28 14:14:38 3768 [ERROR] InnoDB: The system tablespace must be writable!
。。指示权限存在问题。
检查C:\xampp\mysql\data\ibdata1上的权限,并确保运行服务器的用户对该文件夹具有读/写访问权限。
发布于 2015-03-12 02:53:50
只需删除C:\xampp\mysql\data\
文件夹中的ibdata1
和iblog
文件。
https://stackoverflow.com/questions/26617263
复制相似问题