Re: MySQL56 installed on Windows Server 2012 R2 won't start service to finish install

[Barry Galbraith]

><!-- Folders here are:
data\


There should be at least one folder in there too. A \mysql folder holding the mysql database.
It's a working copy of the reference copy in

C:\Program Files (x86)\MySQL\MySQL Server 5.6\data\mysql

Your my.ini folder should have an entry in it like this

datadir="C:/ProgramData/MySQL/MySQL Server 5.6/data/"

That will tell you where your database folders should be located.
You'll also need to ensure that the user starting mysqld has full read/write access to the datadir files/folders.
Normally mysqld is started as a service owned by NETWORK_SERVICE, so NETWORK_SERVICE will need full access to the folders/files.


So to start your server you will need to navigate to
C:\Program Files (x86)\MySQL\MySQL Server 5.6\
then type

bin\mysqld --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.6\my.ini" --console --skip-grant-tables

Good luck,
Barry.