Allowing remote acces to MySQL Step by Step

Guide to Enable remote access to admin MySQL

This is a Guide to Enable remote access to MySQL Server, allowing remote administration and sharing databases.
This guide has been tested in Ubuntu desktop/server 14.04

Run the following commands in a terminal
1- sudo apt-get update
2- sudo apt-get upgrade
3- sudo apt-get install -y mysql-server mysql-common mysql-client libmysqlclient-dev

After mysql has been installed and configured successfully and setted 'root' password, change and comment the following file with an editor(nano, emacs, vi, vim) with 'sudo' logged as admin user or root:
file: sudo nano /etc/mysql/my.cnf
change the following line:
change FROM: bind-address = 127.0.0.1 TO: ## bind-address = 127.0.0.1

Now, run the follow command:
sudo service mysql restart

If MySQL has been restarted successfully then proceed to create a remote user for connect:
1- mysql -u root -p<your_password>
2- CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypass';
3- CREATE USER 'myuser'@'%' IDENTIFIED BY 'mypass';

then:

3- GRANT ALL ON *.* TO 'myuser'@'localhost';
4- GRANT ALL ON *.* TO 'myuser'@'%';

then:
5- flush privileges;

If the line above not return problems, your MySQL is ready to be administered remotely