<commit_before>---
layout: post
title: More MySQL databases easily with ClearDB
date: 2012-08-03 09:00
author: Teemu
comments: true
categories: [mysql, Windows Azure]
---
So you have started to use Azure Websites more and now you are in state where you need an another MySQL DB?
ClearDB is the company that provides the MySQL database that comes with your Azure subscription. But you can only get one from Azure Management portal.
ClearDB itself is ready to offer you more if you want. Here's a guide how to get free MySQL DB from them.

<!--more-->
<ol>
	<li>Open <a href="https://www.cleardb.com/signup.view">https://www.cleardb.com/signup.vie</a>w fill in your information and click create account
<a href="http://tapanila.azurewebsites.net/wp-content/uploads/2012/08/Registeration-Starts.png"><img class="alignnone size-medium wp-image-184" title="Registeration Starts" src="https://res.cloudinary.com/tapanila-net/image/upload/h_279,w_300/v1388360791/Registeration-Starts_wt3ipb.png" alt="" width="300" height="279" /></a></li>
	<li>You will now receive an email from ClearDB. It comes with confirmation link open it. Notice that you can change your username.
<a href="http://tapanila.azurewebsites.net/wp-content/uploads/2012/08/RegisterationUsername.png"><img class="alignnone size-medium wp-image-185" title="RegisterationUsername" src="https://res.cloudinary.com/tapanila-net/image/upload/h_165,w_300/v1388360789/RegisterationUsername_u09prs.png" alt="" width="300" height="165" /></a></li>
	<li>Fill in the last form
<a href="http://tapanila.azurewebsites.net/wp-content/uploads/2012/08/RegisterationBillingAddress.png"><img class="alignnone size-medium wp-image-186" title="RegisterationBillingAddress" src="https://res.cloudinary.com/tapanila-net/image/upload/h_247,w_300/v1388360788/RegisterationBillingAddress_mingry.png" alt="" width="300" height="247" /></a></li>
	<li>Now browse to Azure MySQL db <a href="https://www.cleardb.com/store/azure">offer page</a> and choose free<a href="https://www.cleardb.com/store/azure">
</a><a href="http://tapanila.azurewebsites.net/wp-content/uploads/2012/08/CreateAzureDatabase.png"><img class="alignnone size-medium wp-image-187" title="CreateAzureDatabase" src="https://res.cloudinary.com/tapanila-net/image/upload/h_132,w_300/v1388360787/CreateAzureDatabase_ynzt76.png" alt="" width="300" height="132" /></a><a href="https://www.cleardb.com/store/database_options?plan=Mercury&amp;provider=azure&amp;so=true"> </a></li>
	<li>Choose region and click next
<a href="http://tapanila.azurewebsites.net/wp-content/uploads/2012/08/CreateAzureDatabaseRegion.png"><img class="alignnone size-medium wp-image-188" title="CreateAzureDatabaseRegion" src="https://res.cloudinary.com/tapanila-net/image/upload/h_159,w_300/v1388360786/CreateAzureDatabaseRegion_lihj4x.png" alt="" width="300" height="159" /></a></li>
	<li>Now you are done and can see your Database information.<a href="http://tapanila.azurewebsites.net/wp-content/uploads/2012/08/CreateAzureDatabaseComplete.png">
<img class="alignnone size-medium wp-image-189" title="CreateAzureDatabaseComplete" src="https://res.cloudinary.com/tapanila-net/image/upload/h_195,w_300/v1388360785/CreateAzureDatabaseComplete_xv4ilu.png" alt="" width="300" height="195" /></a></li>
</ol><commit_msg>Fixed old blog post<commit_after>---
layout: post
title: More MySQL databases easily with ClearDB
date: 2012-08-03 09:00
author: Teemu
comments: true
categories: [mysql, Windows Azure]
---
So you have started to use Azure Websites more and now you are in state where you need an another MySQL DB?
ClearDB is the company that provides the MySQL database that comes with your Azure subscription. But you can only get one from Azure Management portal.
ClearDB itself is ready to offer you more if you want. Here's a guide how to get free MySQL DB from them.

1. Open [signup form](https://www.cleardb.com/signup.view) fill in your information and click create account

   ![Registration form](https://res.cloudinary.com/tapanila-net/image/upload/w_610,q_100/v1388360791/Registeration-Starts_wt3ipb.png)
2. You will now receive an email from ClearDB. It comes with confirmation link open it. Notice that you can change your username.

   ![Creating new system user account](https://res.cloudinary.com/tapanila-net/image/upload/q_100,w_610/v1388360789/RegisterationUsername_u09prs.png)
3. Fill in the last form

   ![Registration form billing address information](https://res.cloudinary.com/tapanila-net/image/upload/q_100,w_610/v1388360788/RegisterationBillingAddress_mingry.png)
4. Now browse to Azure MySQL DB [offer page](https://www.cleardb.com/store/azure) and choose free

   ![Creating free azure mysql database](https://res.cloudinary.com/tapanila-net/image/upload/q_100,w_610/v1388360787/CreateAzureDatabase_ynzt76.png)
5. Choose region and click next

   ![Azure MySQL database region](https://res.cloudinary.com/tapanila-net/image/upload/q_100,w_610/v1388360786/CreateAzureDatabaseRegion_lihj4x.pn)
6. Now you are done and can see your Database information.

   ![Database creation completed](https://res.cloudinary.com/tapanila-net/image/upload/q_100,w_610/v1388360785/CreateAzureDatabaseComplete_xv4ilu.png)
{'fraction_non_alphanumeric': 0.1291314373558801, 'fraction_numerical': 0.06264411990776327, 'mean_word_length': 5.622137404580153, 'pattern_counts': {'":': 0, '<': 44, '<?xml version=': 0, '>': 44, 'https://': 19, 'lorem ipsum': 0, 'www.': 7, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '6645804', 'n_tokens_mistral': 1907, 'n_tokens_neox': 1659, 'n_words': 414}