Error in Starting mySql server from command prompt

Question

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 

Answer 1

The same error can also happen if mysqld.exe is already running. Just kill the process.