Allow Mysql 5.7.X running on Ubuntu to connect to any remote hosts.

Host on which mysql running: Ubuntu 16.04
Mysql: 5.7.X

Goto etc/mysql/mysql.conf.d/mysqld.cnf file.

And change the bind-address  to 0.0.0.0 from 127.0.0.1

Add below steps to make your DB root to connect

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password';

CREATE USER 'uname'@'localhost' IDENTIFIED BY 'password';
CREATE USER 'uname'@'%' IDENTIFIED BY 'password';


GRANT ALL ON *.* TO 'uname'@'localhost';
GRANT ALL ON *.* TO 'uname'@'%';

and finally,

FLUSH PRIVILEGES;
EXIT;


Hope it helps to QA and Dev.