We came across MariaDB after a user posted on the RadioDJ forums that they were using it with RadioDJ.
I have to admit I was surprised by how easy it was to install. It’s a lot more straight forward than the normal MySQL installer.
If you have previously had MySQL installed you will need to see this article about removing it as a service
1) Download the Maria DB MSI installer for your version of Windows Here
2) Open the file & Install and run when Windows prompts.
3) On the licence agreement screen check the accept box. Click next.
4) On the next screen will be the components you need to install don’t change anything here just click next.
5) You should now have a screen that says “Modify password for database user root” Enter your desired password.
Only check the “Enable access from remote machines” box if you need it later for stuff like website requests and now playing info.
6) On the next screen you should see this. Keep the default settings apart from the buffer size change that to something like 255MB. Click next.
7) You should then see a tick box “Enable feedback plugin” I didn’t bother enabling it. Just click next if you don’t want to send feedback.
8) You should now have a screen like this.
Click install & If all goes to plan MariaDB server should be installed.
Once you have verified via task manager that SQL is running as a service (mysqld.exe) then you can install the RadioDJ Database.
A quick tutorial on configuring RadioDJ can be found on this page
Setting up a database for use with an automation program needn’t be difficult.