How to connect to the MySQL database for WordPress WebApp in Azure App Services
As we all know that WordPress is one of the most popular CMS (Content Management Systems) available in the world. It’s the no. 1 content management system where Joomla and Drupal comes distance 2nd and 3rd. More details about the CMS can be found here.
As per the wordpress.org the WordPress websites contains around 25% of all the websites available in the internet. Azure WebApp is providing the WordPress web hosting as a PaaS service. When we choose the WebApp for WordPress it will create a MySQL.
Azure AppService now provide two types of WordPress Hosting one is the default WordPress
And the second one is WordPress on Linux which is still on Preview (Released in March this year)
Whatever the option we choose the MySQL database is provided by the ClearDB, not Microsoft.
Recently I have been requested by few users to fix some records in the tables of the MySQL database of the WordPress WebApp hosted in Azure. I will show you how we can connect to the MySQL DB from our workstation.
Generally if you have an Azure WebApp with Custom Domain the minimum default plan which is available is the D1 shared plan. More details about the Azure WebApp plan is available here.
To connect to the MySQL database first I need to go the Application App Service, click on overview and click on the Get publish profile button.
Once the published profile settings is downloaded I have opened it in the notepad or any other text editor. It will show the name of the MySQL database, username and password information as shown below.
Now once I got the MySQL database name, Username and password, I should be able to connect to the MySQL database.
To connect to the MySQL database I need to download the MySQL client which is called MySQLWorkBench and can be downloaded from the MySQL website here.
Once the MySQLWorkBench is downloaded and installed in my workstation I was able to make a connection to the MySQL database over the port number 3306.
Please make sure port number 3306 is allowed in your organization firewall towards internet.
The MySQL connection settings was looking like this.
Once it is configured I have clicked on connect and supply the credentials and it was able to connect to the MySQL database. To test the connection I have clicked on the Test Connection button as shown below
Once it’s connected I was able to see the following screen.
Above I can find the default tables created by WordPress. That’s all about today, I hope this post will help you in the WordPress deployment in future. Good Luck with your Azure App Service.
Nice post. Give a detail understanding of how to connect to MySQL Database