Use MySQL Database on Azure to deploy Joomla! apps

Joomla! is a package of free, open-source content management systems that you can use to build commercial websites, personal blogs, information management systems, and web services. You can also expand the range of Joomla! uses through secondary development. This article explains how to use MySQL Database on Azure to deploy Joomla! apps.

Step 1: Download the latest version of the Joomla! installation package and extract it

  1. Go to the Joomla! 3.6.2 download page, and then select Download.

  2. Save the installation package locally, and then extract it. The installation package downloaded in this example is Joomla_3.6.2-Stable-Full_Package.zip, and it is extracted to C:\Joomla3.6.2.

Step 2: Create a web app

  1. Sign in to the Azure portal and then, in the left pane, select New.

  2. Select Web + Mobile > Web App > Create, and then enter the App Name and Resource Group.
    You can now create or select the App Service Plan/Location. In this example, the URL of the website we created is joomlademo.chinacloudsites.cn.

    3-2

  3. Select Create, and wait for Azure to complete the operation.

Step 3: Create a MySQL database instance on the Azure server and database

Go to the Azure portal to create your MySQL server instance. You can also create the first database for the server instance during the creation process. The database that you create in this example is named joomlademodb001.

Create MySQL server

Note

Ensure that you have selected Allow Azure Services to access the server. Otherwise, the deployment might fail.

Step 4: Upload the content to the /site/wwwroot directory of the web app

Upload all the content that you extracted in "Step 1" to the /site/wwwroot directory of the web app that you created in "Step 2." You can complete this step by using an FTP tool, such as FileZilla, and the FTP access details that you obtain from the web app’s dashboard.

Note

It is important that you save the files and folders in the C:\Joomla3.6.2 directory directly to the /wwwroot directory rather than to the /wwwroot/joomla3.6.2 directory.

Step 5: Configure Joomla! and complete the installation.

Visit the website that you created in "Step 2," and then use a browser to configure Joomla! and complete the installation.

  1. Do either of the following:

    • Open the browser, and then enter the URL of the web app that you created in "Step 2."

    • Select the URL provided on the Azure classic portal dashboard page.

    If the previous steps were completed correctly, this action should take you to the Joomla! installation process page.

  2. Set the website name and administrator account details by using the URL that's displayed on the Azure classic portal web app dashboard, and then select Next.

  3. Configure the following:

    • The database type.
    • The host name, using the server address that is provided on the Azure classic portal MySQL Database on Azure service dashboard.
    • The account, using the user account that you created in "Step 3," taking care to use the format servername%username or username@servername.
    • The database name, using the database name that you created in "Step 3."

  4. Select Next.

  5. If the connection to the server is successful, the Joomla! installation procedure proceeds to Step 3: Preview.

  6. Check all the settings to confirm that there are no errors, and then select Install to finish deploying the Joomla! app.

  7. Select Delete the installation folder on the installation successful page, so that you can continue to perform other operations.