HOW TO GRANT REMOTE ACCESS ON MYSQL 14.14 AND UBUNTU 16.04 LTS

Access you mysql server by terminal :
vi /etc/mysql/mysql.conf.d/mysqld.cnf
comment the line:

from: bind-address = 127.0.0.1

for: #bind-address = 127.0.0.1

execute: service mysql restart

after that, connect on your mysql server and execute this command: 

GRANT ALL PRIVILEGES ON *.* TO '<YOURUSERNAME>'@'<YOUIPD>' IDENTIFIED BY '<YOUPASSWORD>' WITH GRANT OPTION;



SHOW GRANTS;