In case you haven’t already noticed, SQL 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 SQL 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 restricted user Click add user.
3) Choose a new username (Fred), and pick and repeat a secure password,
4) From host % (Access from anywhere)
5) In the “Allow access to” section, expand (But don’t select by ticking the box) global privileges
6) Choose select and insert
Click Save and Close.
You can now configure your web scripts and WordPress plugins to use this new username and password.
This new user is intended for use for scripts only. It doesn’t have the required permissions to run RadioDJ itself, you can either set up a new user in the same way with extra privileges, or use the root account now we’ve removed access for remote hosts.
Last updated on: March 26th, 2017 at 15:12 PM Europe/London
I asked my partner to find out when we actually installed MariaDB on our PC that we run RadioDJ from.
Turns out we’ve had MariaDB installed since June 2014.
Yesterday we upgraded it to the latest version. Which went smoothly after we’d remembered to shut mysqld.exe down as a service.
In the last 15 months that we’ve been using MariaDB we’ve only had 1 maybe 2 issues with a database table becoming corrupted after a sudden shutdown of the computer.
That was easily fixed using Heidisql to repair the tables.
“We could never say the same about another well known automation program. The database in that would crash when you least expected it and was royal pain to fix again. That’s if you were lucky enough to retrieve your database as that program never had a proper database backup tool.
We take a regular daily backups of our database with the RadioDJ database setup tool.
The database in RadioDJ is far more robust and tends not to go wrong unless something major happens on the PC running it.
On the whole MariaDB seems to work like a star.
We’d like to thank the development team at MariaDB for making such a wonderfully stable SQL server program.
What Database Issues? I wouldn’t have a stable reliable music stream without it!
RadioDJ of course has to take some of the credit.
“RadioDJ and MariaDB are the most reliable and stable pieces of software we’ve EVER used and we’ve used lots of other databses”
So next time you’re looking to install a database for use with a radio automation program such as RadioDJ