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 :) Detailshttp://aws.amazon.com/ec2/

First step get an EC2 instance, very simple followhttp://www.edukatr.com/how-to-start-an-ec2-ubuntu-server-for-your-developer-in-6-minutes/

Once you got your ubuntu instance up and running. Install mysqlhttp://www.howtogeek.com/howto/ubuntu/install-mysql-server-5-on-ubuntu/

Now it is time to open port 3306 following steps are fromhttp://stackoverflow.com/questions/5004159/opening-port-80-ec2-amazon-web-services

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 = 127.0.0.1″ 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.