MySQL Forums
Forum List  »  Newbie

Can't start MySQL Server
Posted by: Yuri E
Date: April 18, 2014 06:08PM

I just downloaded the .zip version (http://dev.mysql.com/downloads/mysql/) for Windows 7 x64, extracted on C:\Program Files\MySQL, and ran mysqld.exe. I got this:

C:\Program Files\MySQL\bin>mysqld --console
2014-04-18 20:54:20 0 [Warning] TIMESTAMP with implicit DEFAULT value is depreca
ted. Please use --explicit_defaults_for_timestamp server option (see documentati
on for more details).
2014-04-18 20:54:20 2180 [Warning] Can't create test file C:\Program Files\MySQL
\data\KMW.lower-test
2014-04-18 20:54:20 2180 [Warning] Can't create test file C:\Program Files\MySQL
\data\KMW.lower-test
2014-04-18 20:54:20 2180 [Note] Plugin 'FEDERATED' is disabled.
2014-04-18 20:54:20 2180 [Note] InnoDB: Using atomics to ref count buffer pool p
ages
2014-04-18 20:54:20 2180 [Note] InnoDB: The InnoDB memory heap is disabled
2014-04-18 20:54:20 2180 [Note] InnoDB: Mutexes and rw_locks use Windows interlo
cked functions
2014-04-18 20:54:20 2180 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-04-18 20:54:20 2180 [Note] InnoDB: Not using CPU crc32 instructions
2014-04-18 20:54:20 2180 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-04-18 20:54:20 2180 [Note] InnoDB: Completed initialization of buffer pool
2014-04-18 20:54:20 2180 [ERROR] InnoDB: .\ibdata1 can't be opened in read-write
mode
2014-04-18 20:54:20 2180 [ERROR] InnoDB: The system tablespace must be writable!

2014-04-18 20:54:20 2180 [ERROR] Plugin 'InnoDB' init function returned error.
2014-04-18 20:54:20 2180 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGIN
E failed.
2014-04-18 20:54:20 2180 [ERROR] Unknown/unsupported storage engine: InnoDB
2014-04-18 20:54:20 2180 [ERROR] Aborting

2014-04-18 20:54:20 2180 [Note] Binlog end
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'partition'
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD
'
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'INNODB_METRICS'
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET
'
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'INNODB_CMP'
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'INNODB_TRX'
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'BLACKHOLE'
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'ARCHIVE'
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'MRG_MYISAM'
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'MyISAM'
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'MEMORY'
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'CSV'
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'sha256_password'
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'mysql_old_password'
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'mysql_native_password'
2014-04-18 20:54:20 2180 [Note] Shutting down plugin 'binlog'
2014-04-18 20:54:20 2180 [Note] mysqld: Shutdown complete


I'm a student and I don't know much about how MySQL works. Can anyone help?
Thanks.

Options: ReplyQuote


Subject
Written By
Posted
Can't start MySQL Server
April 18, 2014 06:08PM
April 19, 2014 12:07PM
April 21, 2014 09:48AM
April 21, 2014 10:04AM
April 21, 2014 10:17AM
April 21, 2014 10:37AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.