In this post I am going to show you how to install MySQL 8.* version on a windows 11 machine. For this post I am going to use MySQL 8.4 version.
Open windows Command Prompt with administrative privileges.
Step 1: To install MySQL 8.4 version, we need to have visual studio 2019 x64 redistributable installed in our Windows 11 machine. So first we will install this prerequisite:
Download visual studio 2019 x64 redistributable from the URL:
https://download.visualstudio.microsoft.com/download/pr/c7707d68-d6ce-4479-973e-e2a3dc4341fe/1AD7988C17663CC742B01BEF1A6DF2ED1741173009579AD50A94434E54F56073/VC_redist.x64.exe
Install visual studio 2019 x64 redistributable silently from the command prompt:
VC_redist.x64.exe /q /norestart
Step 2: Create MySQL data directory, in this directory MySQL database going to reside:
mkdir C:\ProgramData\MySQL\Data
Step 3: Create a directory to store MySQL config file:
mkdir C:\ProgramData\MySQL\Config
Step 4: Create mysql.ini config file inside C:\ProgramData\MySQL\Config folder:
[client]
port=3306
[mysql]
no-beep
[mysqld]
port=3306
datadir=C:/ProgramData/MySQL/Data
default-storage-engine=INNODB
lower_case_table_names=1
Step 5: Install MySQL silently
mysql-8.4.0-winx64.msi /qn INSTALLDIR="C:\Program Files\MySQL"
Step 6: Create MySQL Windows Service:
"C:\Program Files\MySQL\bin\mysqld" --install MySQL --defaults-file=C:\ProgramData\MySQL\Config\mysql.ini
Step 7: Initialize MYSQL
"C:\Program Files\MySQL\bin\mysqld" --defaults-file=C:\ProgramData\MySQL\Config\mysql.ini --initialize-insecure
Step 8: Add MySQL Path to environment variable:
setx /M PATH "%PATH%;C:\Program Files\MySQL\bin"
Step 9: Start MySQL service:
net start MySQL
We can add the above commands in a script and run that script as admin user to make this installation completely silent.
No comments:
Post a Comment