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

     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:

     Copy

     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:

     Copy

     C:\ProgramData\MySQL\MySQL Server 8.4

     Ensure hidden items are visible in File Explorer.

     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. 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:

     Copy

     C:\Program Files\MySQL\MySQL Server 8.4\bin

     
   • Open Command Prompt from this location.

     
   • Run the following commands:

     Copy

     mysql --version
     mysql -u root -p

   • Enter the root password when prompted. 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.

   • Execute the master scripts in the MySQL terminal:

     Copy

     SOURCE <path\to\masterscripts>;

     Replace <path\to\masterscripts> with the actual file path.

     
   • Verify available databases:

     Copy

     SHOW DATABASES;

     

   • Exit MySQL:

     Copy

     EXIT;

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