Use MySQL Database on Azure to configure WordPress websites
WordPress is a very widely used CMS. This article explains how to use MySQL Database on Azure and Azure Web Apps to install and configure WordPress.
Step 1: Download the latest version of the WordPress installation package
Download the latest version of the installation package to your local storage directory from the official WordPress website. You can then extract it to this directory.
Step 2: Create a MySQL Database on the Azure server
Use the Azure portal to create your MySQL server.
Ensure that the allowed services are already set to “Yes” in your “configuration”; otherwise, this may cause the deployment to fail. The image below shows that allowed services are set to “Yes” by default.
Create a new MySQL database for WordPress to use (essential)
Switch the workspace to “database,” and click “Create” at the bottom of the screen to create the new database.
Users must manually create the MySQL database in the Azure portal. The WordPress deployment will fail if you miss this step.**
Step 3: Create a new web app
3.1 Logon Azure Managemet Portal, and click "CREATE" button in the bottom left.
3.2 Click "COMPUTE > WEB APP > QUICK CREATE", then enter URL.
3.3 Click "CREATE WEB APP", and wait for Azure to finish the tasks.
Deploy the WordPress installation files
Next, deploy all the WordPress installation files you uncompressed in Step 1 to the new web app. At this point, we recommend that you use Git to complete the deployment process. Refer to Publishing to Azure websites from source control for the specific method.
Step 3 is chiefly intended for new WordPress users. Some of you have already used Azure Web Apps and successfully deployed the WordPress installation files and begun using them. To keep the content consistent, we recommend that you export the data and then reimport it after you reinstall and deploy WordPress and successfully connect to a new MySQL database. Complete the specific WordPress data import and export procedures by using the WordPress control panel (as shown in the image below).
Step 4: Install and configure WordPress
Access and deploy the web app
In order to access the web app you created earlier, go to the WordPress configuration page and select the required language. The content in the image below will then appear on the screen.
Connect and configure the MySQL database
Enter the configuration details for the database created in Step 2 into the interface shown in the image below.
If you see what appears in the image below, WordPress is now connected to MySQL.
Click to proceed with the installation, and finish deploying WordPress.
Step 5: Use WordPress
Once you have completed the process above, if you access the web app that you created earlier, you will find that the main WordPress interface now works. You are ready to start using WordPress.