Microsoft Azure Open Source Development Support Team Blog

Support for Open Source Technologies on Microsoft Azure App Service

Migrating data between MySQL databases using kudu console – Azure App Service

NOTE: Always keep multiple backup’s of your database before migration. There are often times when you want to migrate data from one MySQL server to another. This maybe because you are migrating from an On-Premise environment to Azure or upgrading a ClearDB database to a different tier or other reasons. Database migration can be done… Read more

How to upgrade ClearDB database for Azure App Service

If you are using ClearDB as your MySQL database on Azure, you probably know that there is no upgrade path available on Azure portal. The only way to upgrade would be through ClearDB dashboard. You will need to put your credit card information on ClearDB portal to upgrade your database. This blog talks about how… Read more

WordPress: Error establishing a database connection

If you see the infamous “Error establishing a database connection“, enable WordPress Debug Logging by following the steps outlined here: http://blogs.msdn.com/b/azureossds/archive/2015/10/09/logging-php-errors-in-wordpress.aspx     Debug.log will be saved within wp-content folder. Possible error messages in debug.log: [25-Jul-2016 15:34:44 UTC] PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user ‘be96d626d450b1’@’23.102.165.199’ (using password: YES) in D:\home\site\wwwroot\wp-includes\wp-db.php on line 1490 [25-Jul-2016 15:34:44… Read more

Troubleshooting MySQL Database on ClearDB

This article covers some common scenarios customers may run into using ClearDB with Microsoft Azure. For reference, here is a link to the ClearDB FAQ: https://www.cleardb.com/developers/help/faq As listed on the ClearDB FAQ, there are some general guidelines for using ClearDB. These guidelines include limitations on: Maximum Database Connections Maximum Database Size Maximum SELECT Query Execution… Read more