Creating a new SQL user

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

Click to enlarge

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.

 

Requested By…..

RadioDJ version 1.6.5.0 was released yesterday and what a release!

The program just gets better & better.

Now RadioDJ has a better and improved request system.

You can now Include the username of the person who requested the song in the stream title.

Something that you needed a badly written PAL script for within SAM Broadcaster.

Screenshot from 2013-10-09 09:43:47

You can achieve this by adding this code to requests under Options > Stream titles. Choose requests from the list and paste this into the box.

$artist$ - $title$ [Requested By $request_username$]

Don’t forget to click save!

There is also an option to include a message but personally I think that would take up to much space in a title stream.

The demo request PHP script for RadioDJ can be found Here.

If you haven’t tried out RadioDJ what are you waiting for?

RadioDJ Free radio automation download

RadioDJ is FREE doesn’t require messy pal scripts to do basic functions.

Translate »