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).

edited Oct 28 "13 at 20:47

RolandoMySQLDBA

1,837 1 9 22

asked Oct 28 "13 at 18:56

Shaun Wild

134 1 2 8

1

This is how I feel right now: i.imgur.com/xVyoSl.jpg – Shaun Wild Oct 28 "13 at 18:56

1

install mysql workbench and try accessing it from there – Shekhar Oct 28 "13 at 19:16

add a comment

3 Answers

active oldest votes

up vote 2 down vote accepted

Make sure the mysqld.exe is ticked under the Startup tab when you go to run and type msconfig. Also, same goes for Services, look for the MySQL services there, right click > properties and make sure the startup types are selected as automatic.

answered Oct 28 "13 at 19:02

Rudolph

1,60421428

how do I just run the server? – Shaun Wild Oct 28 "13 at 19:03

Have you tried to run it manually? Just by starting mysqld.exe? I can only verify the exact services tomorrow at work, do not know them out of my head. – Rudolph Oct 28 "13 at 19:05

Yes, please check my question. – Shaun Wild Oct 28 "13 at 19:26

2

I set the service as automatic an restart my computer, job done. Thanks! – Shaun Wild Oct 28 "13 at 20:05

add a comment

up vote 2 down vote

If you installed MySQL using the MSI installer, it should be setup as a service.

You can open the service in two ways

METHOD #1 : Access the Installed Service

Open up the Services Icon in the Control Panel
Scroll alphabetically to the MySQL Service
Right Click the Service
Click Start Service

METHOD #2 : Command Line Execution

Open DOS Window
From the C: Prompt, run this: net start mysql

If you get this error

C:\Windows\system32>net start mysql
System error 5 has occurred.

Access is denied.

C:\Windows\system32>

then you didn"t run the DOS Window as Administrator. Try again as Administrator. You should see:

C:\Windows\system32>net start mysql
The MySQL service is starting..
The MySQL service was started successfully.


C:\Windows\system32>

Give it a Try !!!

answered Oct 28 "13 at 20:04

RolandoMySQLDBA

1,8371922

add a comment

up vote -2 down vote

In order to start manually the mysql serve you must run the mysqld executable. Open the command prompt and type:

shell> "C:\Program Files\MySQL\MySQLServer\bin\mysqld"

If mysqld doesn"t start, check the error log. The error log is located in the C:\Program Files\MySQL\MySQLServer\data. It is the file with a suffix of .err. You can also try to start the server as mysqld --console; in this case, you may get some useful information on the screen that may help solve the problem.

The last option is to start mysqld with the --standalone and --debug options. In this case, mysqld writes a log file C:\mysqld.trace that should contain the reason why mysqld doesn"t start.

Source

stackoverflow.com

کلمات کلیدی:

نوشته شده توسط Abteen 94/10/10:: 9:42 عصر | () نظر