This article will help you understand how you can install and set up MySQL in a virtual machine in Azure. Basically Azure virtual machine is a computer which you can configure according to your needs. It allows load balance traffic, so if you host your website or anything in the virtual machines, it will be fast enough. We can set up the virtual machines from your azure portal. If you are new to azure virtual machine, I strongly recommend you to read here: Create Virtual Machine In Azure. It will be great if you have any existing MSDN subscription with you before you go with this. Now we will discuss more about installing MySQL in a virtual machine in Azure. I hope you will like this.

If you are new to azure, I recommend you to read here: Azure

Background

There are so many reasons why you should go with a virtual machine. I will share with you what exactly my need was. I was using a cleardb for my wordpress website. I was some having some limitation that 20 MB as the database size. For me that was not sufficient, and after my db crosses the limit, I was not able to login to my wordpress dashboard. I was getting some database errors when I try to login to admin. So I decided to create a virtual machine and install a MySQL there. This article helps you to install MySQL in virtual machine.

Steps to Install MySQL in Azure Virtual Machine

Login to your azure portal https://manage.windowsazure.com

Login to your Azure Virtual Machine

Go to start and click on the Internet Explorer

Install MySQL in Azure Virtual Machine

Before going to download and install MySQL, you need to set some settings in Internet Explorer.

Install MySQL in Azure Virtual Machine

What we are going to do is, adding MySQL site name to trusted site in IE.

Install MySQL in Azure Virtual Machine

Please follows the steps as shown in these images.

Install MySQL in Azure Virtual Machine

Now add http://*.mysql.com to the trusted site.

Install MySQL in Azure Virtual Machine

Now type http://dev.mysql.com/downloads/mysql in the URL area, and click enter.

Install MySQL in Azure Virtual Machine

Do not need to mind the warnings you get, so please close those.

Install MySQL in Azure Virtual Machine

Now you can see the MySQL installer home page as shown below.

Install MySQL in Azure Virtual Machine

Leave the warning, and close it.

Install MySQL in Azure Virtual Machine

No, you will be asking to sign up, if you want you can do that, or else you can just skip it.

Install MySQL in Azure Virtual Machine

Now an executable file will be downloaded, you can either directly run it from the browser or you can just double click on that file.

Install MySQL in Azure Virtual Machine

I hope your installation has been started now.

Install MySQL in Azure Virtual Machine

Once it is done, please read the license agreement and click next.

Install MySQL in Azure Virtual Machine

As I do not need any development stuffs and I am not going to do any development there, so I just selected server only. You can select as per your needs.

Install MySQL in Azure Virtual Machine

In the type and networking section, please make sure that you have enabled ‘Show Advanced Options’ as shown below.

Install MySQL in Azure Virtual Machine

Click next and give your MySQL Root Password in the next window. Please make sure that you have given a complex password.

Install MySQL in Azure Virtual Machine

Click on the Add User.

Install MySQL in Azure Virtual Machine

Type the asked details.

Install MySQL in Azure Virtual Machine

You can set all host if you want to access it from everywhere, or you can select local host. Choose wisely as your need.

Install MySQL in Azure Virtual Machine

I hope you have added a user, now please click next.

Install MySQL in Azure Virtual Machine

Now you will be in Windows Service section. Please make sure that ‘Start MySQL Server at System Startup’ is enable. And do not change any other settings.

Install MySQL in Azure Virtual Machine

Now you will be shown advanced option which is nothing but the settings for error log informations. Do not need to change anything there. Just click next.

Install MySQL in Azure Virtual Machine

Please click on Execute, to apply the server configuration.

Install MySQL in Azure Virtual Machine

Click the Finish button, once the server configuration is applied successfully.

Install MySQL in Azure Virtual Machine

Now if you can you can copy the log to clipboard, or you can click Finish.

Install MySQL in Azure Virtual Machine

It seems we have done everything, Now we will check whether MySQL has been installed or not. Shall we? Please go to the start menu and type MySQL.

Install MySQL in Azure Virtual Machine

Wow, that’s great we did it.

Conclusion

Did I miss anything that you may think which is needed?.Have you ever tried virtual machine in azure?. If not, I strongly recommend that. Did you ever installed MySQL in your system? I hope you liked this article. Please share me your valuable suggestions and feedback.

Your turn. What do you think?

A blog isn’t a blog without comments, but do try to stay on topic. If you have a question unrelated to this post, you’re better off posting it on C# Corner, Code Project, Stack Overflow, Asp.Net Forum instead of commenting here. Tweet or email me a link to your question there and I’ll definitely try to help if I am able to.

Kindest Regards
Sibeesh Venu