DJ Garybaldy - The Only sound you need

In case you haven't already noticed MySQL tends to allow some pretty insecure permissions by default, allowing root access from any computer. This is a big problem, especially if you have port forwarding configured on your router to your MySQL instance. However you can easily create new users using any management interface, so we'll do it with HeidiSQL 1) Launch HeidiSQL and sign in as root. 2) Select Tools>User Manager. First of all, we'll remove root access for remote hosts. There will be several accounts listed for root, from various locations. Select the root account that has just a % sign in the host column. This allows root access from any location, including on the internet and isn't recommended. On the right hand side, select the drop down and pick the local network that matches your LAN IP range (e.g. 192.168.%) This makes sure that when you're on your local network, you can still log in as root. Click save. Next we'll add a new r

So you've successfully installed and configured the RadioDJ database. Now you have it installed its a good idea if once in a while you do some basic maintenance to ensure optimum operation. Its not that difficult to maintain and backup your RadioDJ database. A backup of your SQL database is essential in case the worst should happen to your computer. First: We'll look at the RadioDJ database backup utility. Open database setup from the setup folder select the auto backup tab and set it to backup your database at a set Hour. TIP: Backup your database to a directory or drive of your choice You can never have too many backups The database backup happens in the background Tick the box that says close to the system tray Close to tray and FORGET about it. Fact: Other paid for radio automation doesn't backup the whole database Next we will move onto the other part of the maintenance with HeidiSQL HeidiSQL should have already been installe