Screencast: Using MySQL Workbench with Windows Azure Web Sites

One of the great things about Windows Azure Web Sites is being able to create a web site in seconds that uses MySQL for your data. With your Azure subscription, you are entitled to a free MySQL database. You can’t manage this database within the Azure portal, but you can connect to it using MySQL Workbench.

In this screencast, I demonstrate how you can connect to your MySQL database using MySQL Workbench. I also show you how to find out the size of your MySQL database.

Download MySQL Workbench free from the Internet.

Here is the SQL query that I used in the screencast to determine the size of my database. You will need to change the query so that it uses your database name.

SELECT table_schema "your_database_name",
sum( data_length + index_length ) / 1024 / 1024 "Database Size in MB"
FROM information_schema.TABLES GROUP BY table_schema ;