In this article, you will see how do you install MySQL server 8.0.27 on the Windows 10 operating system using a zip archive file.
Table of Contents
Software Dependency
- MySQL Server 8.0.27 [zip]
- Windows 10
How do we install MySQL server on Windows 10(64-bit)?
Steps to install MySql server on windows 10 64-bit operating system:
- Download MySql zip Archive file
- Extract the Zip Archive File
- Configure system environment variables
- Initialize the data directory and database
- Start MySQL Service and Connect to the Server
Download MySQL zip Archive file
First, we have to download the zip archive file from its official website download page. On the download page, select the operating system as Microsoft Windows and choose Windows (x86, 64-bit), ZIP Archive, then click on the download button as you can see in the below image.
Once you click on the download button, it will open the below page. Here, you just need to click on the link No thanks, just start my download to start downloading.
Extract the Zip Archive File
Once you download the zip archive, you have to extract it at the desired location. In this article, we have extracted it at C:\MySQL\mysql-8.0.27-winx64
Create MySQL configuration file
The configuration file is used to initiate the MySQL database server. Create a new my.ini file and a data Folder inside the base directory.
Base directory: C:/MySQL/mysql-8.0.27-winx64
Now, put the following content in the my.ini document. You can use a plain text editor(eg. notepad or notepad++) to create this file.
[mysqld]
# set basedir to your installation path
basedir="C:/MySQL/mysql-8.0.27-winx64"
# set datadir to the location of your data directory
datadir="C:/MySQL/mysql-8.0.27-winx64/data"
# Set up port
port=3306
# Maximum connections allowed
max_connections=200
# Number of connection failures allowed .
max_connect_errors=10
# The character set used by the server defaults to UTF8
character-set-server=utf8
# The default storage engine that will be used when creating a new table
default-storage-engine=INNODB
[mysql]
# Set up mysql Client default character set
default-character-set=utf8
[client]
# Set up mysql The default port when the client connects to the server
port=3306
default-character-set=utf8
Configure system environment variables
System Environment Variables path:
Right click on MyComputer -> properties -> Advanced System Settings -> Environment variables
Now, click on the Environment Variables button > add MYSQL_HOME & Path variables with the following value:
| Variable name | Variable value |
|---|---|
| MYSQL_HOME | C:/MySQL/mysql-8.0.27-winx64 |
| Path | %MYSQL_HOME%\bin |
Initialize the data directory and database
The ZIP archive of MySQL does not include the data directory; therefore, we must initialize it manually. When we initialize MySQL, it creates the MySQL system database files and system tables in the specified data directory.
Data directory: C:/MySQL/mysql-8.0.27-winx64/data
To initialize MySQL and create a MySQL database, we must run the mysqld command with the –initialize or –initialize-insecure option. The meaning of using these options are as follow:
| –initialize | This option is considered secure by default. In this case, MySQL generates a random root password. Once installation completes, the root password will be expired, and you must create a new root password. |
| –initialize-insecure | In this option, we do not need to specify the root password. It is considered that the user will create the root password before moving on to production. |
Here, we will use the –initialize option to initialize it.
Now, open the command prompt as an administrator user. Jump to the C:/MySQL/mysql-8.0.27-winx64/bin directory, and run the following command:
C:\MySQL\mysql-8.0.27-winx64\bin>mysqld --initialize
The above command will take a few minutes to initialize the MySQL database. To verify the successful initialization, open the data directory(C:/MySQL/mysql-8.0.27-winx64/data). You can see the data directories and system database files have been created, which indicates that the initialization was completed successfully.
During the initialization process, MySQL writes the logs in the data directory of MySQL. You can use it to review them or diagnose any issue. The file name format of the error log is [Host Name].err. In this file, we can see our randomly created password for the user root as follow:
A temporary password is generated for root@localhost: k_?W)BxTo3q2
NOTE:
If you got any .dll file missing error while initializing mysql, then visit the https://www.dll-files.com/ to download and paste it at location C:\Windows\System32 in your computer.
Start MySQL Service and Connect to the Server
To start the MySQL service, run the following command:
C:\MySQL\mysql-8.0.27-winx64\bin>mysqld
Now the service has been started successfully. Don’t close this command prompt window until you want to stop it.
Now, connect to the MySQL server using mysql command-line tools. Start another session of command prompt and run the following command. Provide the randomly created password here,
mysql -u root -p
You are now connected to the MySQL server.
If you want to change the password for the root user, do it as follow:
mysql> ALTER USER root@localhost IDENTIFIED BY '123456';
Conclusion
In this article, you have seen the installation process step by step using the zip archive file. It is completely different from the installation process of MySQL using MSI installer. The installer is a GUI tool that makes the installation process much easier than the MySQL zip archive installation process.