Windows Azure provides the MySQL database but unfortunately we do not have any portal feature to work with the MySQL database associated with the Windows Azure WebSite. There is always a way,
Let’s assume I have created a WebSite which has MySQL. For example I have created the website from gallery and selected the WordPress which comes with MySQL database. So I will have a MySQL database with it and I can read the connection string from the portal.
And the connection string would look like something
After I have it I can use any MySQL management tool to connect my database to it. I have tested it with MySQL Workbench.
Then you are ready to work with your MySQL Database and manage through this tool.
I started getting this error after I had one Web Platform Installer download issue while updating my Windows Azure SDK 2.0. So I had uninstalled all the Windows Azure component from my control panel and was still getting “IISConfigurator.exe has stopped working”.
I was trying a many things but some how when I changed the below and selected “IIS Management Console” it worked like a charm.
After installing the new Windows Azure SDK 2.0 I am happy to see this new Server Explorer component which lets me connect and manipulate Windows Azure Storage Component.
After I click there, I am able to associate the same management certificate which I have used to connect my Visual Studio 2012 for deployment.
After I select the account it would show the available storages. And I can choose from them.
Once it is pointed, I will be able to browse individual elements like Blob, Queue and Table.
I can view the Table and also can add values there.
This is really handy.