Link MySQL Database To Azure Virtual Machine And WordPress

The next step is a bit complex one. You need to enter a complex command which is shown here.

For your convenience I am giving the following command:

You can type the following command:

And if you do the above step correctly, I am sure you will be given a result as follows.

Wow, we have done the settings needed now.

Now we need to change some settings in our wordpress configuration. As you all know the wordpress configuration is in the file called wp-config.php. So we are going to change the configuration in that file.

Changing the configuration to new settings in wordpress.

Again go to your manage azure page, click the web application you need to change the settings.

Now go to the dashboard and click Edit in Visual Studio Online.

You can see your wordpress files now. Click on the wp-config.php.

It is always better to take a back up or copy of the wp-config.php, so that you can revert back to your clearDB configuration whenever you want. I strongly recommend you to do this step.

You can rename the pasted file, just right click on the file and click Rename.

As you can see in the following image, I have given the name ClearDB-Wp-Config.php.

Open your wp-config.php and change the MySQL host name.

Now add the port number in the host name because it listen that port.

Please do not forget to change the database name, user name, password too.

Now I am sure your blog with new MySQL database will be running . Keep blogging. Cheers!.

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. So we have successfully configured our new MySQL database to the Azure virtual machine and wordpress. We have also done the firewall changes needed in virtual machine. 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. Write your questions and feedback in the comments section below.