RadioDJ With MySQL on my Zyxel NSA325

I had a local MySQL for my RadioDJ, until my computer got issues and would not start up anymore. So I wanted to have a central MySQL and my NAS should be able to run a MySQL server.

It’s easy to install at System Setting – Firmware/Packages
Next I added a user for RadioDJ and set the permissions. However, after starting the RadioDJ database setup it said my RadioDJ workstation didn’t had access to the server:

I needed to grant the user for my network. In my case, I noticed in the error message the machinename adds the modem name:

host ‘machinename.modem.name’ is not allowed to connect to this server

So, after a small search on internet, I have to create an extra user for the access:

CREATE USER 'RadioDJ_User'@'%.modem.name' IDENTIFIED BY 'secretpassword'

The ‘%’ is a wildcard, it should only allow users that exists in the workgroup of the modem.  Next I set all privileges:

GRANT ALL PRIVILEGES ON *.* TO 'RadioDJ_User'@'%.modem.name' WITH GRANT OPTION;

With the database setup I now had access and I created a RadioDJ database. Next I restored my most recent backup.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s