# OvalEdge DB on Azure MySQL

This article provides step-by-step instructions to set up an Azure-based MySQL database environment. It covers the creation of an Azure Database for MySQL instance and the execution of initialization scripts. This setup supports database configuration required for application deployment and metadata operations.

### Prerequisites

Ensure the following conditions are met before proceeding:

* **Azure Access:** Valid access to the Azure Portal with required permissions
* **Azure Subscription:** Active Azure subscription for resource provisioning
* **Resource Group:** Existing resource group or permission to create a new one
* **Compute Access:** Access to an Ubuntu virtual machine for database connectivity
* **SQL Scripts:** Availability of required MySQL initialization scripts

### Installation Steps

1. Create Azure Database for MySQL
   * Log in to the Azure Portal using valid credentials. Select **Create a resource**.\
     \
     \&#xNAN;***Sample Reference Screenshot***

     <figure><img src="/files/Z4K4BI1cvNAxObkkZV1F" alt=""><figcaption></figcaption></figure>

   * Search for **Azure Database for MySQL** and select it. Select Create.\
     \
     \&#xNAN;***Sample Reference Screenshot***

     <figure><img src="/files/JbJgTOglifX0gue3uO9k" alt=""><figcaption></figcaption></figure>

2. Configure Database Settings
   * Select the appropriate **Subscription**.

   * Select an existing **Resource Group** or create a new one.

   * Enter a unique **Server Name**.

   * Select the required **Region**.\
     \
     \&#xNAN;***Sample Reference Screenshot***

     <figure><img src="/files/65CjhdbnCaoPebS20tDf" alt=""><figcaption></figcaption></figure>

   * Select the appropriate **Pricing Tier** based on performance requirements.\
     The Business Tier 1 option is suitable for business-critical workloads and provides high performance and reliability.\
     \
     \&#xNAN;***Sample Reference Screenshot***

     <figure><img src="/files/TfHlzOJYY8siOof7cNL1" alt=""><figcaption></figcaption></figure>

   * Enter the **Administrator Username** and **Password** for the MySQL server, and proceed to Networking.\
     \
     \&#xNAN;***Sample Reference Screenshot***

     <figure><img src="/files/EYeRHSjBjQaYqXYySeJm" alt=""><figcaption></figcaption></figure>

   * Proceed to the **Networking configuration**.<br>

3. Configure Network Settings
   * Select **Connectivity Method** as **Private Access (VNet Integration).**

   * Select the required **Virtual Network**.\
     \
     \&#xNAN;***Sample Reference Screenshot***

     <figure><img src="/files/gqNkbqJi4kZmuFdrCppK" alt=""><figcaption></figcaption></figure>

   * Proceed to the **Security configuration**.<br>

4. Review and Create&#x20;
   * Review all configuration settings.
   * Select **Create** to deploy the database.
   * After deployment, navigate to the Overview page and note the following:\\
     * Server Name
     * Administrator Username
     * Database Name<br>

5. Connect to Azure MySQL from Ubuntu VM
   * Connect to the Ubuntu virtual machine.
   * Update system packages:

     ```bash
     sudo apt update
     ```
   * Install MySQL client:

     ```bash
     sudo apt install mysql-client -y
     ```
   * Verify MySQL client installation:

     ```bash
     mysql --version
     ```
   * Connect to the Azure MySQL server:

     ```bash
     mysql -h <MYSQL_HOSTNAME> -u <USERNAME> -p
     ```

6. Execute Initialization Script
   * Run the required database initialization script after establishing the connection:

     ```bash
     source <script_file_path>/01.R6.3_MasterScripts_FreshInstallation.sql;
     ```

     \
     **Sample Reference Screenshot:**

     <figure><img src="/files/ZkHkTqLGj8CM7Xq8SW0H" alt=""><figcaption></figcaption></figure>

***

Copyright © 2026, OvalEdge LLC, Peachtree Corners, GA, USA.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.ovaledge.com/release8.1/deployment-and-maintenance/installation/ovaledge-db-on-azure-mysql.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
