Mysql adding user for remote access

Standard

IN order to connect remotely you have to have MySQL bind port: 3306 to your machines IP in my.cnf. Then you have to have created the user in both localhost and ‘%’ wildcard and grant permissions on all DB’s as such . See below:

my.cnf

#Replace xxx with your IP Address 
bind-address        = xxx.xxx.xxx.xxx

then

CREATEUSER'myuser'@'localhost' IDENTIFIED BY'mypass';CREATEUSER'myuser'@'%' IDENTIFIED BY'mypass';

Then

GRANTALLON*.*TO'myuser'@'localhost';GRANTALLON*.*TO'myuser'@'%';

Depending on your OS you may have to open port 3306 to allow remote connections.

Referensi link -> http://stackoverflow.com/questions/16287559/mysql-adding-user-for-remote-access