MySQL refuses to "Start Service"

O

overlord20

Gawd
Joined
Feb 5, 2010
Messages
623
Okay so here it goes. I successfully installed Apache and PHP just fine. Now I start installing MySQL, it will install BUT when I got to execute the software I get the red X by "Start Service" and then continue to receive "Could not start the service MySQL. Error: 0".

After I get this I head into my event viewer and pull 4 different error messages.

  1. Plugin 'InnoDB' init function returned error.
  2. Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
  3. Unknown/unsupported storage engine: INNODB
  4. Aborting
This is in order..

Then the .ERR file says this:
110922 20:39:22 [Note] Plugin 'FEDERATED' is disabled.
110922 20:39:22 InnoDB: The InnoDB memory heap is disabled
110922 20:39:22 InnoDB: Mutexes and rw_locks use Windows interlocked functions
110922 20:39:22 InnoDB: Compressed tables use zlib 1.2.3
110922 20:39:22 InnoDB: Error: unable to create temporary file; errno: 2
110922 20:39:22 [ERROR] Plugin 'InnoDB' init function returned error.
110922 20:39:22 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
110922 20:39:22 [ERROR] Unknown/unsupported storage engine: INNODB
110922 20:39:22 [ERROR] Aborting
Click to expand...

I have googled and all and I don't feel comfortable installing the manual way yet, BUT if it is the only option I most certainly will.
 
"110922 20:39:22 InnoDB: Error: unable to create temporary file; errno: 2"
I suspect this is the real error and you have a file permission issue somewhere.
 
Any idea where to go from there? There are a lot of files so...

Run the program as admin and enable writing in I:/windows?

(For some reason my boot drive is I: after a reinstall)


EDIT:

I believed it worked.. We will see :)

EDIT EDIT:

Everything is working fantastic after I let MySQL write to C:/Windows/
 
Last edited:
Dev machine.. The only people who have access to the stuff is myself and a couple friends to play minecraft.
 
You must log in or register to reply here.
Back
Top