For some tasks on your MySQL server, you will need a user that can access your server from other computers than localhost, for example if your using our RadioDJ wordpress plugin.

By default, the root user which comes with a fresh install of MySQL server can only access the server from the same computer as your MySQL server (localhost/127.0.0.1) and also this user has too many powerful privileges, that can be dangerous to be allowed for a remote user.

In this screen cast i will show you how to add another MySQL user that can be connected from any computer and with limited privileges. For this i will use HeidiSQL a free tool that works great and is also available as a portable application.

You will notice that each user has two entries, one for localhost and one for the remote. It is not a mistake.

[styled_box title=”NOTE” class=”sb_green”]It is a good idea to avoid selecting the DELETE privilege for this type of user (not like i did in this tutorial).[/styled_box]