How To Add A Remote MySQL User
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.
