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:
- Open C:\Program Files\MySQL Server 5.5\my.cnf
- Find the line
datadir=”C:/ProgramData/MySQL/MySQL Server 5.5/Data/” - Change it to
datadir=”C:/Program Files/MySQL/MySQL Server 5.5/Data/” - Start the MySQL service again, and it will start straight away.