Installing MySQL community server using a noinstall ZIP Archive in windows 10/11

README.md

Installing MySQL community server using a noinstall ZIP Archive in windows 10/11

1. Download the Archived file by selecting MySQL version and OS version using this link

2. Create a new folder inside C:\ folder as mysql

3. Extract the zip file and copy all the contents within the folder and paste it inside the mysql folder

4. Inside the mysql folder create a new file named my.ini and paste the following config

[mysqld]

# set basedir to your installation path
basedir=C:\\mysql

# set datadir to the location of your data directory
datadir=C:\\mysql\\data

5. Go inside mysql/bin folder in terminal and run the following commands

mysqld.exe --initialize-insecure

mysqld.exe --install

6. Press the Windows key and search for services, open services and search for a service named MySQL
7. Right click on the service and select start
8. Open a new termainal and invoke the following command to check if mysql server is accessible

mysql -u root --skip-password

9. To give root user a password run the following inside the mysql server you opened on previous step

ALTER USER 'root'@'localhost' IDENTIFIED BY 'ENTER_YOUR_PASSWORD_HERE';

FLUSH PRIVILEGES;

10. Type the password after invoking the command. that's it!

mysql -u root -p