sudo vim /etc/mysql/my.cnf
###change:
...
bind-address = 0.0.0.0
...
mysql -u root -p
use mysql
GRANT ALL ON *.* to root@'<HOST MACHINE IP>' IDENTIFIED BY 'root';
FLUSH PRIVILEGES;
exit
service mysql restart
sudo vim /etc/mysql/my.cnf
###change:
...
bind-address = 0.0.0.0
...
mysql -u root -p
use mysql
GRANT ALL ON *.* to root@'<HOST MACHINE IP>' IDENTIFIED BY 'root';
FLUSH PRIVILEGES;
exit
service mysql restart