Prime number generator
March 30, 2011
osCommerce Stock Level Hack
May 26, 2011

MySQL 5.5.12 Config Wizard Bug

Installing JIRA on a Windows 2008 R2 x64 server today, and had to install MySQL for the database back end.

Sounds simple enough… It’s been a while since I setup MySQL on a Windows installation, so I was pleasantly surprised to see the installation wizard pop up to ask me about the server and it’s role etc.

This wizard seems great.

However, come to the end, and it fails to start the MySQL service.

Looking in Windows event logs shows that the MySQL service is unable to write to C:\ProgramData\MySQL Server 5.5\data\

The Fix:

  1. Open C:\Program Files\MySQL Server 5.5\my.cnf
  2. Find the line
    datadir=”C:/ProgramData/MySQL/MySQL Server 5.5/Data/”
  3. Change it to
    datadir=”C:/Program Files/MySQL/MySQL Server 5.5/Data/”
  4. Start the MySQL service again, and it will start straight away.

Leave a Reply

Redirecting shortly

%d bloggers like this: