To have a free your own cloud mysql server, First you need an instance of amazon ec2 which is free for first year of your trial :) Details

First step get an EC2 instance, very simple follow

Once you got your ubuntu instance up and running. Install mysql

Now it is time to open port 3306 following steps are from

This is actually really easy:

  • Go to the Security Group settings in the left hand navigation
  • Find the Security Group that your instance is apart of
  • Click on Inbound Rules
  • Use the drop down and add HTTP (port 80)
  • Click Apply and enjoy

now ssh into ubunutu server using Your keyfile edit “/etc/mysql/my.cnf” and comment line “bind-address =″ or put a “#” in front of it

restart mysql

sudo service mysql restart

Create a new database and create new user with host ‘%’

CREATE DATABASE IF NOT EXISTS mydatabase; GRANT ALL on mydatabase.* to 'mydatabaseuser'@'%' identified by 'mydatabasepass';

Thats.. it now just like u connect to a local mysql from command line, connect to this one by changing the host to be the ip of the cloud amazon server.