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. Click the download button on the download page of the official Joomla! website (Joomla! 3.6.2 download page).

  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 classic portal, and then click the New button at the lower left.

  2. Click Compute > Web App > Quick Create, and then enter the URL. (In this example, the website URL is joomlademo.chinacloudsites.cn.)

  3. Click Create Web App, and then wait for Azure to complete the operation.

Step 3: Create a MySQL Database on Azure server and database

  1. Sign in to the Azure classic portal, and then click the New button at the lower left.

  2. Click Data Services > MySQL Database on Azure > Quick Create, enter the server name, select the server version and location, and then create the database username and password for sign-in. (In this example, the address for the database we create is joomlademo.mysqldb.chinacloudapi.cn, and the username is joomlademo%demouser.)

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

  4. After the server creation is complete, to create the database, go to the database management page for the server, and then click the Add button at the bottom.

  5. To finish creating the database, enter the database name. (In this example, the name of the database is joomlademodb001.)

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.
    • Click 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 (using the URL provided on the Azure classic portal web app dashboard), and then click Next.

  3. Configure the database type, host name (using the server address that is provided on the Azure classic portal MySQL Database on Azure service dashboard), account (using the user account created in Step 3.2 and taking care to use the format servername%username or username@servername), and database name (using the database name that you created in Step 3.5), and then click Next.

  4. If the connection to the server is successful, the Joomla! installation procedure will proceed to Step 3: Preview. Check all the settings to confirm that there are no errors, and then click Install to finish deploying the Joomla! app.

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