Download the MySQL Community Server binary distribution from the official Oracle web site. Select the appropriate ZIP archive matching your system architecture (typically x86_64 for modern Windows environments).

Extract the downloaded archive to your designated installation directory, such as:

D:\Database\MySQL

Add the binary directory to your system PATH environment variable:

D:\Database\MySQL\bin

Create a configuration file named my.ini in the installation root with the following content. Modify the path directives to match your extraction location:

[mysqld]
port=3307
basedir=D:/Database/MySQL
datadir=D:/Database/MySQL/datadir
max_connections=150
max_connect_errors=5
character-set-server=utf8mb4
collation-server=utf8mb4_0900_ai_ci
default-storage-engine=InnoDB
[mysql]
default-character-set=utf8mb4
[client]
port=3307
default-character-set=utf8mb4

Launch Command Prompt with Administrator privileges and initialize the data directory:

mysqld --initialize --console

The initialization process generates a temporary password for the root account. Note the credentials displayed in the terminal output:

[Server] A temporary password is generated for root@localhost: Xk#7mP2$vLq9

Install the MySQL instance as a Windows service:

mysqld --install MySQL80

Start the database service:

net start MySQL80

Connect to the server using the temporary password generated during initialization:

mysql -u root -p -P 3307

Execute the following SQL command to update the root account credentials:

ALTER USER 'root'@'localhost' IDENTIFIED BY 'SecurePass2024!';