Step by Step Tutorial To Setup MySQL Database Server on Microsoft Azure

Setting Up the MySQL Database Server on Microsoft Azure Virtual Machine...

Following are the steps -

1. Login to the Azure Management Portal by going to the following link –

https://manage.windowsazure.com

Enter the your user credentials –

Username: your username

Password: your password

2. Go to the Virtual Machines window by clicking on the ‘Virtual Machines’ tab on the left side of the Azure Management Portal.

3.  Click on the ‘New’ button at the bottom to create a new virtual machine.

4. Inside the ‘New’ Grid window click on ‘Compute’, then ‘Virtual Machine’ and finally ‘Quick Create’. This would open up a small form to enter the details of the Virtual Machine.

5. In The ‘DNS Name’ text-field, enter the name of the virtual machine of your choice which has the extension of .cloudapp.net (anyname.cloudapp.net).

6. In the ‘Image’ section, select the copy of the virtual machine image you want to run (Windows Server 2012 R2 Datacenter).

7. Now select the ‘Size’ you want to allocate to the Virtual Machine in terms of CPU cores and the memory (RAM).

8. Next enter the user credentials (Username: anyusername, Password: anypassword).

9. At last select the ‘Region/Affinity Group’ from the list of regions to opt for a particular region where the virtual machine would reside (East US).

10. Finally click on the ‘Create Virtual Machine’ button. Now you can see a notification saying “Creating Virtual Machine…”

11. Once the Virtual Machine is configured and ready, you’ll see a notification saying “Successfully created virtual machine vm_name”.

12.  Now you can check the ‘Status’ of the Virtual Machine changed to ‘Running’ in the Virtual Machine window.

13. When the Virtual Machine is in the Running state, you can click on the Virtual Machine and navigate to various tabs like Dashboard, Monitor, Endpoints & Configure to check and edit the details of the VM.

14. Now for connecting to the Virtual Machine, go to the Dashboard. In the dashboard window, click on the “Connect” button on the Bottom.

15. Clicking on the ‘Connect’ button, a .rdp (remote desktop protocol) file will be downloaded. Save the file on the personal computer for establishing the connection to the Virtual Machine from your windows machine.

16. Open the .rdp file downloaded from Azure. It would ask for user credentials. Enter the user credentials mentioned earlier in the process of configuring the Virtual Machine. Also a security certificate prompt will open, click on OK to trust the source and wait for the Remote Desktop Connection to commence. In a few seconds you will be inside your Virtual Machine (Windows Server 2012 R2 Datacenter).

17. Now inside your Virtual Machine, download the MySQL Community Server from the following link –

http://dev.mysql.com/downloads/mysql/

18. Open the installation file for MySQL and start the installation process. Click on Typical mode for installation. And wait for it to complete the installation.

19. Click on Finish to complete the MySQL installation. Next the MySQL Configuration wizard will open.

20. Click on next. Then check the option for ‘Standard’ Installation, click on Next.

21. Now check the option for both ‘Install as a Windows Service’ and ‘Include Bin Directory in Windows PATH’.

22. Now enter the password for the MySQL server, then click on Next.

23. Now click on Execute to commit the configurations and wait for it to complete.

24. Click on Finish to complete. Now the database server is ready.

25. To check the connection of the database server from a remote system/computer execute the following command from MySQL Command Line Tool installed on the remote system –

mysql –u username –p –h anyname.cloudapp.net

password: your password

26. After this you are into the MySQL database server hosted on the Microsoft Azure Virtual Machine.