MySQL 8.0.22 zip compressed package version (free installation) download, installation and configuration steps detailed

Hello everyone, today I encountered some problems while learning the installation and configuration of MySQL 8.0.22. I specially shared my entire installation process in the hope of helping friends who don’t know how to install it😜. Reference Links

The first step is to download MySQL

Go to the MySQL official website to download, follow the steps shown in the figure, and wait patiently for the download to complete:

Friends can also download it through the network disk🤦‍♂️

Link: https://pan.baidu.com/s/1FgKuST9ftpXbrvyInJ8fUg

Extraction code: 6cxk

Step 2: Unzip the downloaded compressed package

After the download is complete, unzip the compressed package to the disk you want to place it, as shown below:

The third step is to configure the my.ini file

There is no my.ini file in the unzipped directory. You can create it yourself in the my.ini file added to the installation root directory ( create a new text file and change the file type to .ini ), and write the basic configuration:

[mysqld]
# Set port 3306 port=3306
# Set the installation directory of MySQL basedir=C:\Program Files\MySQL
# Set the storage directory of MySQL database data datadir=C:\Program Files\MySQL\Data
# Maximum number of connections allowed max_connections=200
# The number of connection failures allowed.
max_connect_errors=10
# The default character set used by the server is utf8mb4
character-set-server=utf8mb4
# The default storage engine that will be used when creating a new table default-storage-engine=INNODB
#Default authentication is done with the "mysql_native_password" plugin #mysql_native_password
default_authentication_plugin=mysql_native_password
[mysql]
# Set the default character set of the mysql client to default-character-set=utf8mb4
[client]
# Set the default port used by the mysql client to connect to the server port = 3306
default-character-set=utf8mb4 

After the settings are completed, it will be as shown below:

Step 4: Run CMD as an administrator

Initialize MySQL. During installation, in order to avoid errors due to permission issues, we use 👍Administrator identity👍 to run CMD. Otherwise, an error will be reported during installation, resulting in installation failure, as shown in the following figure:

Step 5: Enter the MySQL installation directory

After opening, enter the bin directory of mysql and enter cd + space + your path, as shown below:

Step 6 Initialization

Enter mysqld --initialize --console in the bin directory under the MySQL directory, as shown below:

Step 7: Install, start, and log in to the MySQL service

step

1. Enter mysqld --install [服務名]（服務名可以不加默認為mysql） to install the MySQL service.
2. After the service is successfully installed, enter net start mysql（啟動MySQL的服務）
3. Login
4.The effect is shown in the figure below:

Step 8: Modify the initialization password

Order:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'new password';

Note: The semicolon at the end of the command must be there, this is the syntax of MySQL.

The following figure takes setting the "root" password as an example, as shown below:

Step 9: Verify the changed password

step

1. Reopen the CMD (normal account is fine) window
2. Enter the bin directory where MySQL is installed
3. Enter the account root and the modified password to log in
4.The effect is shown in the figure below:

At this point, the installation and deployment is complete. Officials say that MySQL 8.0 is twice as fast as 5.0 in test speed.

Supplement: Configure environment variables

In order to start MySQL from any location in CMD, configure the environment variables

1. Right-click "My Computer" on the desktop >> "Properties", and click "Advanced System Settings" on the pop-up page (different computers or systems may be different)

2. In the "System Properties" window that pops up, click the "Environment Variables" button under the "Advanced" tab.

3. Set the Path environment variable in the system variables . The variable already exists, so select Path in the list and click the "Edit" button below, as shown in the figure:

4. Add the following information in the pop-up window: D:\devlop\mysql-8.0.22-winx64\bin and click the "Confirm" button, as shown in the figure:

5. Verify whether the configuration is successful

Reopen a CMD window and enter the username and password as shown in the figure. The configuration is successful

hint:

When you are not using MySQL, stop the MySQL service in the CMD (Administrator) window. After the MySQL service is started, you can log in as a normal MySQL user.
Command: Install MySQL service: mysqld --install Uninstall MySQL service: mysqld --remove Start MySQL service: net start mysql Stop MySQL service: net stop mysql

At this point, you can use MySQL easily and happily

To facilitate the management of MySQL database, you can also install Navicat for MySQL and other graphical management clients for MySQL databases.

Conclusion 😁

This is the end of this article about the download, installation and configuration steps of MySQL 8.0.22 zip compressed package version (installation-free). For more information about the installation and configuration of MySQL 8.0.22 zip compressed package version, please search for previous articles on 123WORDPRESS.COM or continue to browse the related articles below. I hope everyone will support 123WORDPRESS.COM in the future!