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:
#Replace xxx with your IP Address bind-address = xxx.xxx.xxx.xxx
CREATEUSER'myuser'@'localhost' IDENTIFIED BY'mypass';CREATEUSER'myuser'@'%' IDENTIFIED BY'mypass';
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