Connect MySQL Remotely, Amazon EC2 using MySQL Workbench

Login to AWS Management Console. Under the security group, add inbound rule for MySQL.

First login to EC2 instance using SSH, then login to mysql 

mysql -hlocalhost -uroot -p

provide the password. Once you are in mysql prompt

CREATE USER 'testuser'@'%' IDENTIFIED BY 'testpwd'

GRANT ALL PRIVILEGES ON *.* TO 'testuser'@'%' WITH GRANT OPTION

FLUSH PRIVILEGES

Note: Setting host to '%' may be harmful, you can set your IP address to access the MySQL from your IP address only

Now open the my.cnf file from /etc/mysql and search for bind-address, the default value will be

bind-address = 127.0.0.1

change it to

 bind-address = 0.0.0.0

That's it now go to MySQL workbench, create connection with

Host:

Username: testuser