Technical
How To Set Up Remote Access On Mysql

To access mysql remotely you need to do the following:

1. Create user which is allowed to be used outside of the localhost
   

   
    grant all on db_dev.* to 'monozub'@'%' identified by '';
   

2. Change my.cnf (on ubuntu it’s located in /etc/mysql) settings for bind-address to include remote ip
   

   
   - bind-address = localhost
   + bind-address = 0.0.0.0
   

   NOTE: this case above will accept connection from ANY ip address.
   ALSO: if you specify remote address rather then localhost root will be
   able to access machine in any way regardless.
3. Don’t forget to restart ( sudo /etc/init.d/mysql restart )