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 –
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 –
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.