Azure: Quick and Easy way to create a Dreamspark Web App and MySQL, using the Azure Marketplace
Well in a previous blog I talked about connecting your MySQL database with your Web App, but that was the hard way! I noticed that you can use the Azure Marketplace to quickly build your Web App and MySQL database. I am not sure why I didn’t notice this before, but it is quick and easy!
Sources:
- Got this idea from:
- Create a PHP-MySQL web app in Azure App Service and deploy using Git
- If you read the referenced article above, contained inside of the article is also an explanation on how to use the Marketplace to quickly build a Web App + MySql.
- Get Dreamspark at: https://www.dreamspark.com/Product/Product.aspx?productid=99
- Azure portal
:
This article will only show you how to implement a web app + MySql using the Marketplace. Usually you need to have a credit card to use the MarketPlace, but for the Web App + MySql you do not need a credit card!
So to use this fast and easy approach to building a Web App and MySql database do the following:
- Start the Azure portal by going to https://azure.microsoft.com
Create a New Web App + MySql from Marketplace
In the portal click on the New button in the upper right hand of the portal
Use the Marketplace
Click on the Marketplace on the Create blade
- Use the Search bar of the MarketPlace type Web App + MySql
Use the “MarketPlace” to generate your Web App + MySql
Click on the Web App + MySQL, click on the “Create” button at the bottom of the page and fill in the information, I will let you figure out all of that stuff.
Fill in the “Configure required settings”
Fill in the “configure required settings”information and then click Ok
- URL: Must be unique, adding numbers after a desired name works.
- Create a new AppService plan, which is used so that you can share features across your various apps
- Click OK
Select or create your MySql database
Select the database or create a new one, you only get one database, the image below indicates that I have selected the existing MySql database, click create and you have completed the web app + MySql.
Conclusion
The instructions in this blog has shown you how to easily create an empty Web App and empty MySql database. These can be used by Visual Studio to create a Web App, Web Job and connect to the MySql database. You can use PHP or other tools to work with the Dreamspark Azure offering.