I've installed a MySQL server onto my computer and when I first installed it, it ran automatically. Now I've restarted my computer it is no longer running. What file do I need to run to get it back up and running again?
I've tried running MySQL 5.6 Command Line Client and
mysqld.exe from the
Program Files/MySQL/MySQLServer/bin directory, and I've had no luck.
Upon running mysqld.exe, I get the following error:
2013-10-28 18:52:12 4788 [ERROR] InnoDB: .\ibdata1 can't be opened in read-write mode 2013-10-28 18:52:12 4788 [ERROR] InnoDB: The system tablespace must be writable! 2013-10-28 18:52:12 4788 [ERROR] Plugin 'InnoDB' init function returned error. 2013-10-28 18:52:12 4788 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2013-10-28 18:52:12 4788 [ERROR] Unknown/unsupported storage engine: InnoDB 2013-10-28 18:52:12 4788 [ERROR] Aborting`
Naturally, I tried running it as administrator, and I got this:
C:\Windows\system32>"C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe" 2013-10-28 19:24:30 0 [Warning] TIMESTAMP with implicit DEFAULT value is depreca ted. Please use --explicit_defaults_for_timestamp server option (see documentati on for more details).