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