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.

 

image

 

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.

image

Then you are ready to work with your MySQL Database and manage through this tool.

image

Namoskar!!!