MySQLlässt sich nicht öffnen

Irgendwelche Probleme mit XAMPP für Windows? Dann ist hier genau der richtige Ort um nachzufragen.

MySQLlässt sich nicht öffnen

Postby Eisvogel1 » 18. August 2015 18:10

Hallo zusammen,

APACHE lässt sich ganz normal starten, aber MySQL Bericht sofort ab. Die Log-Datei sieht folgendermaßen aus – was kann ich tun?:

2015-08-18 18:40:42 4904 [Note] Plugin 'FEDERATED' is disabled.
2015-08-18 18:40:42 7dc 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.
2015-08-18 18:40:42 4904 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-08-18 18:40:42 4904 [Note] InnoDB: The InnoDB memory heap is disabled
2015-08-18 18:40:42 4904 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-08-18 18:40:42 4904 [Note] InnoDB: Memory barrier is not used
2015-08-18 18:40:42 4904 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-08-18 18:40:42 4904 [Note] InnoDB: Not using CPU crc32 instructions
2015-08-18 18:40:42 4904 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-08-18 18:40:42 4904 [Note] InnoDB: Completed initialization of buffer pool
2015-08-18 18:40:42 4904 [ERROR] InnoDB: F:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2015-08-18 18:40:42 4904 [ERROR] InnoDB: The system tablespace must be writable!
2015-08-18 18:40:42 4904 [ERROR] Plugin 'InnoDB' init function returned error.
2015-08-18 18:40:42 4904 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2015-08-18 18:40:42 4904 [ERROR] Unknown/unsupported storage engine: InnoDB
2015-08-18 18:40:42 4904 [ERROR] Aborting

2015-08-18 18:40:42 4904 [Note] Binlog end
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'partition'
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'INNODB_METRICS'
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'INNODB_CMP'
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'INNODB_TRX'
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'BLACKHOLE'
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'ARCHIVE'
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'MRG_MYISAM'
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'MyISAM'
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'MEMORY'
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'CSV'
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'sha256_password'
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'mysql_old_password'
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'mysql_native_password'
2015-08-18 18:40:42 4904 [Note] Shutting down plugin 'binlog'
2015-08-18 18:40:42 4904 [Note] f:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2015-08-18 18:40:48 2168 [Note] Plugin 'FEDERATED' is disabled.
2015-08-18 18:40:48 1e8c 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.
2015-08-18 18:40:48 2168 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-08-18 18:40:48 2168 [Note] InnoDB: The InnoDB memory heap is disabled
2015-08-18 18:40:48 2168 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-08-18 18:40:48 2168 [Note] InnoDB: Memory barrier is not used
2015-08-18 18:40:48 2168 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-08-18 18:40:48 2168 [Note] InnoDB: Not using CPU crc32 instructions
2015-08-18 18:40:48 2168 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-08-18 18:40:48 2168 [Note] InnoDB: Completed initialization of buffer pool
2015-08-18 18:40:48 2168 [ERROR] InnoDB: F:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2015-08-18 18:40:48 2168 [ERROR] InnoDB: The system tablespace must be writable!
2015-08-18 18:40:48 2168 [ERROR] Plugin 'InnoDB' init function returned error.
2015-08-18 18:40:48 2168 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2015-08-18 18:40:48 2168 [ERROR] Unknown/unsupported storage engine: InnoDB
2015-08-18 18:40:48 2168 [ERROR] Aborting

2015-08-18 18:40:48 2168 [Note] Binlog end
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'partition'
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'INNODB_METRICS'
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'INNODB_CMP'
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'INNODB_TRX'
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'BLACKHOLE'
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'ARCHIVE'
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'MRG_MYISAM'
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'MyISAM'
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'MEMORY'
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'CSV'
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'sha256_password'
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'mysql_old_password'
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'mysql_native_password'
2015-08-18 18:40:48 2168 [Note] Shutting down plugin 'binlog'
2015-08-18 18:40:48 2168 [Note] f:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2015-08-18 18:42:00 6412 [Note] Plugin 'FEDERATED' is disabled.
2015-08-18 18:42:00 12e8 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.
2015-08-18 18:42:00 6412 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-08-18 18:42:00 6412 [Note] InnoDB: The InnoDB memory heap is disabled
2015-08-18 18:42:00 6412 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-08-18 18:42:00 6412 [Note] InnoDB: Memory barrier is not used
2015-08-18 18:42:00 6412 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-08-18 18:42:00 6412 [Note] InnoDB: Not using CPU crc32 instructions
2015-08-18 18:42:00 6412 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-08-18 18:42:00 6412 [Note] InnoDB: Completed initialization of buffer pool
2015-08-18 18:42:00 6412 [ERROR] InnoDB: F:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2015-08-18 18:42:00 6412 [ERROR] InnoDB: The system tablespace must be writable!
2015-08-18 18:42:00 6412 [ERROR] Plugin 'InnoDB' init function returned error.
2015-08-18 18:42:00 6412 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2015-08-18 18:42:00 6412 [ERROR] Unknown/unsupported storage engine: InnoDB
2015-08-18 18:42:00 6412 [ERROR] Aborting

2015-08-18 18:42:00 6412 [Note] Binlog end
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'partition'
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'INNODB_METRICS'
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'INNODB_CMPMEM'
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'INNODB_CMP'
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'INNODB_LOCKS'
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'INNODB_TRX'
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'BLACKHOLE'
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'ARCHIVE'
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'MRG_MYISAM'
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'MyISAM'
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'MEMORY'
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'CSV'
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'sha256_password'
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'mysql_old_password'
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'mysql_native_password'
2015-08-18 18:42:00 6412 [Note] Shutting down plugin 'binlog'
2015-08-18 18:42:00 6412 [Note] f:\xampp\mysql\bin\mysqld.exe: Shutdown complete
danke für die Hilfe, ich bin blutiger Anfänger
Eisvogel1
 
Posts: 2
Joined: 18. August 2015 17:58
Operating System: Windows 7

Re: MySQLlässt sich nicht öffnen

Postby Nobbie » 19. August 2015 08:30

>F:\xampp\mysql\data\ibdata1 can't be opened in read-write mode

Das ist das Problem. Ich weiß nicht, was F: ist, wahrscheinlich ein NAS oder so, aber das ist nicht lesbar für MySQL, welches (als Service?) unter einer anderen UserID läuft als Deine eigene UserID.

Als "blutiger Anfänger" wäre es ggf. sinnvoll, die Anweisung zu befolgen, Xampp in C: zu installieren und ggf. das UAC von Windows auszuschalten.
Nobbie
 
Posts: 8775
Joined: 09. March 2008 13:04

Re: MySQLlässt sich nicht öffnen

Postby Eisvogel1 » 19. August 2015 14:19

danke für die schnelle Antwort!F: ist die Partition auf C:, auf denen ich meine Programme installieren (insofern hätte es uns gepasst). Aber ich glaube, es ist wirklich einfacher, direkt auf C: zu gehen
Eisvogel1
 
Posts: 2
Joined: 18. August 2015 17:58
Operating System: Windows 7


Return to XAMPP für Windows

Who is online

Users browsing this forum: No registered users and 13 guests