Unable to start MySQL service in version 1.8.3

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Unable to start MySQL service in version 1.8.3

Postby poddarrishabh » 01. August 2013 15:51

I have just installed XAMPP 1.8.3 and I am not able to start the MySQL service.

This is the error message in the control panel:
7:43:22 AM [mysql] Error: MySQL shutdown unexpectedly.
7:43:22 AM [mysql] This may be due to a blocked port, missing dependencies,
7:43:22 AM [mysql] improper privileges, a crash, or a shutdown by another method.
7:43:22 AM [mysql] Press the Logs button to view error logs and check
7:43:22 AM [mysql] the Windows Event Viewer for more clues
7:43:22 AM [mysql] If you need more help, copy and post this
7:43:22 AM [mysql] entire log window on the forums


This is the error message in the Log:
2013-08-01 07:38:09 5352 [Note] InnoDB: The InnoDB memory heap is disabled
2013-08-01 07:38:09 5352 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-08-01 07:38:09 5352 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-08-01 07:38:09 5352 [Note] InnoDB: Not using CPU crc32 instructions
2013-08-01 07:38:09 5352 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2013-08-01 07:38:09 5352 [Note] InnoDB: Completed initialization of buffer pool
2013-08-01 07:38:09 5352 [ERROR] InnoDB: read can't be opened in C:\Softwares\xampp\mysql\data\ibdata1 mode
2013-08-01 07:38:09 5352 [ERROR] InnoDB: The system tablespace must be writable!
2013-08-01 07:38:09 5352 [ERROR] Plugin 'InnoDB' init function returned error.
2013-08-01 07:38:09 5352 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2013-08-01 07:38:09 5352 [ERROR] Unknown/unsupported storage engine: InnoDB
2013-08-01 07:38:09 5352 [ERROR] Aborting

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

I have made sure that:
1. I have no other software similar to XAMPP in my computer that can cause trouble.
2. Windows firewall has allowed complete access and is not blocking the service.
3. I have changed the port number MySQL uses through the config files (just to be safe)
poddarrishabh
 
Posts: 1
Joined: 01. August 2013 15:32
Operating System: Windows 8

Re: Unable to start MySQL service in version 1.8.3

Postby wharsono » 03. August 2013 19:16

Sorry about my English.

I Have same situation on Win7 Ultimate, the error message is :

01:09:46 [mysql] Error: MySQL shutdown unexpectedly.
01:09:46 [mysql] This may be due to a blocked port, missing dependencies,
01:09:46 [mysql] improper privileges, a crash, or a shutdown by another method.
01:09:46 [mysql] Press the Logs button to view error logs and check
01:09:46 [mysql] the Windows Event Viewer for more clues
01:09:46 [mysql] If you need more help, copy and post this
01:09:46 [mysql] entire log window on the forums

please guide me

Thx
wharsono
 
Posts: 1
Joined: 03. August 2013 19:11
Operating System: Win7 Ultimate


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 129 guests