How to enable MySQL remote access?
You need to change the bind-address parameter to the IP you wish to allow remote access to.  However, most people just comment out the bind-address parameter in the my.cnf file to allow access from anywhere and deal with who can access the DB server with user access control.  I would suggest the latter and not the former. Don't forget to restart mysql server after making changes to my.cnf for the changes to take effect.

Please refer Here for more information.

Additionally, The grant statement should have single quotes around the name as well as the host:

mysql&gt; GRANT ALL ON foo.* TO 'bar'@'192.168.0.1' IDENTIFIED BY 'PASSWORD';


Also, don't forget to 

Flush privileges;