命令提示符下启动MySQL服务器,从命令提示符启动MySQL服务器时出错

I am new to sql , I installed mysql and I am following the book : Java how to program to connect to mysql

I am getting the following error.

Regarding timestamp.. I understand the reason.. but i am trying to fix "Can't create test file C:\Program Files\MySQL\MySQL Server 5.6\data\Swati-HP.lower-test"

Please guide me wit respect to this

C:\Users\Swati>mysqld.exe

2013-10-15 13:57:01 0 [Warning] TIMESTAMP with implicit DEFAULT value is depreca

ted. Please use --explicit_defaults_for_timestamp server option (see documentati

on for more details).

2013-10-15 13:57:01 7492 [Warning] Can't create test file C:\Program Files\MySQL

\MySQL Server 5.6\data\Swati-HP.lower-test

2013-10-15 13:57:01 7492 [Warning] Can't create test file C:\Program Files\MySQL

\MySQL Server 5.6\data\Swati-HP.lower-test

2013-10-15 13:57:01 7492 [Note] Plugin 'FEDERATED' is disabled.

2013-10-15 13:57:01 7492 [Note] InnoDB: The InnoDB memory heap is disabled

2013-10-15 13:57:01 7492 [Note] InnoDB: Mutexes and rw_locks use Windows interlo

cked functions

2013-10-15 13:57:01 7492 [Note] InnoDB: Compressed tables use zlib 1.2.3

2013-10-15 13:57:01 7492 [Note] InnoDB: Not using CPU crc32 instructions

2013-10-15 13:57:01 7492 [Note] InnoDB: Initializing buffer pool, size = 128.0M

2013-10-15 13:57:01 7492 [Note] InnoDB: Completed initialization of buffer pool

2013-10-15 13:57:01 7492 [ERROR] InnoDB: .\ibdata1 can't be opened in read-write

mode

2013-10-15 13:57:01 7492 [ERROR] InnoDB: The system tablespace must be writable!

2013-10-15 13:57:01 7492 [ERROR] Plugin 'InnoDB' init function returned error.

2013-10-15 13:57:01 7492 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGIN

E failed.

2013-10-15 13:57:01 7492 [ERROR] Unknown/unsupported storage engine: InnoDB

2013-10-15 13:57:01 7492 [ERROR] Aborting

2013-10-15 13:57:01 7492 [Note] Binlog end

2013-10-15 13:57:01 7492 [Note] Shutting down plugin 'partition'

.

.

.

.

.

2013-10-15 13:57:01 7492 [Note] mysqld.exe: Shutdown complete

解决方案

Folder "program files" in windows is usually restrict write for non-admin accounts, so you can either:

run mysql under admin account - not very good practice

set write rights for this folder for all - not very good practice

move data storage into another place and change my.cnf appropriately - right one