Creating a Fedora machine with MYSQL on Amazon

1. Login to AWS console
2. Start a machine with AMI:- ami-2547a34c
3. Make sure required ports are open in the security group that you used
• MYSQL:-3306
• SSH:- 22
  
4. After the server is up, login to the server using ssh
5. Install the mysql server :-

    yum -y install mysql mysql-devel mysql-server

6. start the server:-

   /etc/init.d/mysqld start

7. By default, mysql doesn;'t provide any password for root. This is dangerous, so first thing you do is set a password:-

   mysqladmin -u root password 

8. By default root has permissions to only login from localhost. So, give permission to root to login from anywhere:-

   mysql -u root -p
   
    grant all on *.* to root@'%'

That's it.. now you can login to MYSQL from your local machine using Toad or any other client