Connecting and Managing MySQL of Windows Azure
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
|Database=wrijuwpA55ISymtc;Data Source=us-cdbr-azure-northcentral-a.cleardb.com;User Id=UserName;Password=*******|
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.