In my previous post, click here, I mentioned and described few of the features of WAWS, cloud offering from Microsoft. As I mentioned we could associate a application with either the MySQL db or Microsoft’s own SQL Server db. There is a small twist in the story though. MySQL is owned by ClearDB and there is no UI on Windows Azure to manage MySQL db.
Windows Azure has a web interface/UI for managing SQL Server db. Here is a snapshot of the same:
Windows Azure portal for managing SQL Server databases
Last week, one of the consumers of the Windows Azure wanted to know how to retrieve the MySQL connection string so that he could use it with other application that he had on Azure. This could get tricky. As I said earlier, there is no UI for managing MySQL database. So the question is how does one retrieve the connection string if he wishes to.
Before I proceed ahead on how to retrieve the connection string let me show you how do you create a MySQL db on Windows Azure.
Creating a MySQL db on Windows Azure Web Sites
So I created a site (kaushal-mysql) to use a MySQL database successfully. Now lets proceed to the next step where we can retrieve/view the connection string.
Retrieving/Viewing the MySQL Connection String
In order to be able to the view the connection string the MySQL Db should be linked to the site i.e., if you go to the LINKED RESOURCES section then you should see that the corresponding MySQL db.
There you go! Here is the MySQL connection string that you were looking for. Obviously this will also show the SQL Server connection string in case the site was created with a SQL Server db.
So ensure that the database is linked to the site in order to view the connection string. Once you have copied the connection string. You could unlink and use that connection string in another application.
That's it for today folks. Hope this helps someone. Until then ciao!