# MySQL 8.4.x on Windows This article outlines the steps to install MySQL on a Windows machine using the **.msi installer package** provided by OvalEdge. By following this guide, users can install MySQL, configure basic settings, and apply recommended system parameters to ensure optimal performance. ## Prerequisites Ensure the following before proceeding: * The user should be using a **Windows operating system** (Windows 10 or later is recommended). * The user should have **administrative privileges** on the system. * An **active internet connection** (for downloading the installer, if not already available). * Basic knowledge of **Windows navigation** and **command prompt usage**. ## MySQL Installation Steps 1. Download MySQL Installer * Download the MySQL installer from the link below:\ [MySQL 8.4.5 MSI from OvalEdge](https://ovaledge.s3.us-west-1.amazonaws.com/scripts/packages/mysql-8.4.5-winx64.msi)

Download the latest MySQL 8.4.x MSI file from the official website:
https://dev.mysql.com/downloads/mysql/8.4.html

2. Run the Installer * Double-click the downloaded **.msi file**.
* When the **MySQL Server 8.4 Setup** pop-up window appears, click **Next** to continue.
* On the **End-User License Agreement** page, read and accept the terms, then click **Next**.
* On the **Choose Setup Type** page, select **Typical setup**, then click **Next**.
* On the **Ready to Install MySQL Server 8.4** page, click **Install**.
* Ensure the **Run MySQL Configurator** box is checked, then click **Finish**.
3. Configure MySQL * In the **Welcome** section of the MySQL Configurator, click **Next**.
* In the **Data Directory** section, either change the default path or keep the default, then click **Next**.
* In the **Type and Networking** section, keep default settings unless specific changes are needed, then click **Next**.
* In the **Accounts and Roles** section, set the **MySQL root password**, then click **Next**.
* In the **Windows Service** section, a MySQL service will be created with default settings. Click **Next**.
* In the **Server File Permissions** section, permissions will be set automatically. Click **Next**.
* In the **Sample Databases** section, skip creating sample databases by clicking **Next**.
* In the **Apply Configuration** section, click **Execute**.
* In the **Configuration Complete** section, click **Finish** when successful.
### Post-Installation Configuration 1. Apply OvalEdge Recommended Parameters * Edit the MySQL configuration file **my.ini** to include the following parameters: ``` max_binlog_size=xxxM max_allowed_packet=xxxM binlog_expire_logs_seconds=xxxxx group_concat_max_len=xxxxx innodb_buffer_pool_size=xxxxx ```

The GCS team will provide the above parameters according to the infrastructure size during deployment.

* Navigate to: ``` C:\ProgramData\MySQL\MySQL Server 8.4 ```

Ensure hidden items are visible in File Explorer.

\ \&#xNAN;*Sample Reference Screenshots:*
* Open **my.ini** in a text editor (e.g., Notepad++ or VS Code).
* Locate the **\[mysqld]** section and add the parameters under this block.\ \ \&#xNAN;*Sample Reference Screenshot:*
* Save and close the file. * Restart the MySQL service to apply changes.
2. Restart MySQL Service * Open the **Start menu** and search for **Services**.
* Locate **MySQL84** in the list.
* Right-click on the service and select **Restart**. ### Verify Installation 1. Check MySQL Version and Login * Navigate to the MySQL **bin directory**: ``` C:\Program Files\MySQL\MySQL Server 8.4\bin ```
* Open **Command Prompt** from this location.
* Run the following commands: ``` mysql --version mysql -u root -p ``` * Enter the **root password** when prompted.\ \ \&#xNAN;*Sample Reference Screenshot:*
### Run Master Scripts 1. Executing Master Scripts * The GCS team will provide the **master script download link** during deployment.
* Once downloaded, right-click the file → **Properties → Security tab** → copy the full path to the script.\ ![](https://1813356899-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FhTnkoJQml0pok9awFDhx%2Fuploads%2FC2OMPUMQYrgpUHkVA0Ji%2Fimage.png?alt=media\&token=11a16bd9-d302-4b66-97d4-caa8b63a9796) * Execute the master scripts in the MySQL terminal: ``` SOURCE ; ``` \ Replace `` with the actual file path.
* Verify available databases: ``` SHOW DATABASES; ``` \ ![](https://1813356899-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FhTnkoJQml0pok9awFDhx%2Fuploads%2F0m0J3i8ChuMytQf1oynG%2Fimage.png?alt=media\&token=56f7b294-2088-4972-8827-bc1b8246425d) * Exit MySQL: ``` EXIT; ``` *** Copyright © 2025, OvalEdge LLC, Peachtree Corners, GA, USA.