MySQL 8.0.22 compressed package complete installation and configuration tutorial diagram (tested and effective)

1. Download the zip installation package

Click here to download the MySQL server 8.0.22 compressed package

After downloading, just unzip it

2. Unzip and configure environment variables

2.1 Unzip the zip package to the installation directory. I unzipped it to D:\MySQL\mysql-8.0.22-winx64 2.2 Configure environment variables

Add the bin path in the unzipped folder to the variable value, starting with ; and ending with

2.3 Create and configure the initialization my.ini file

Put it in the installation directory

The content of the configuration file my.ini is as follows:

[mysqld]
# Set port 3306 port=3306
# Set the installation directory of mysql basedir=D:/MySQL/mysql-8.0.22-winx64 # Remember to use double slashes \\ here. I will make an error if I use a single slash, or I will use a single slash. Try it yourself # Set the storage directory of mysql database data datadir=D:/MySQL/mysql-8.0.22-winx64/data # Same as above # Allow the maximum number of connections max_connections=200
# The number of connection failures allowed. This is to prevent someone from trying to attack the database system from this host max_connect_errors = 10
# The default character set used by the server is UTF8
character-set-server=utf8
# The default storage engine that will be used when creating a new table default-storage-engine=INNODB
# By default, the "mysql_native_password" plug-in is used for authentication. default_authentication_plugin=mysql_native_password
[mysql]
# Set the default character set of the mysql client to default-character-set=utf8
[client]
# Set the default port used by the mysql client to connect to the server port = 3306
default-character-set=utf8

3. Install MySQL

3.1. Right-click on the Windows logo in the lower left corner of the system and select "Command Prompt (Administrator)":

Note: The control command console must be run as an administrator!

3.2. In the control console, enter the bin directory of the MySQL that you just unpacked:

3.3. Initialize MySQL database

Command: mysqld --initialize-insecure
Function: Initialize the database and set the default root password to empty. After the initialization is completed, the data folder will be automatically generated in the mysql root directory, as shown in the following figure:

Note: Initialization is complete only when three folders appear as shown in the figure above!

3.4. Install MySQL service for Windows system

Enter the execution command: mysqld install [service name]
Function: Install MySQL service for Windows system, the default service name is: mysql
Note: The service name behind it can be omitted, the default name is mysql. Of course, if you need to install multiple MySQL services on your computer, you can distinguish them with different names, such as mysql5 and mysql8.

3.5. Start the mysql service

After the installation is complete, you can start the MySQL service through the command net start mysql. Stop the service using the command net stop mysql. Uninstall the MySQL service using the command sc delete MySQL/mysqld -remove

3.6. Change password

Execute the command in the bin directory of the MySQL installation directory:
mysql -u root -p
At this time, you will be prompted to enter the password. Just press Enter (the empty password is set above) to log in successfully and enter the MySQL command mode. Change the password (changing the password is necessary or you cannot set up a remote connection)
Switch to mysql and execute the command:

use mysql;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';

After that, the setting is successful. At this time, the mysql user name is: root and the password is: root
Finally, exit and log in again as root. The username for the remote connection is root and the password is root.

This is the end of this article about the complete installation and configuration tutorial of MySQL 8.0.22 compressed package (tested and effective). For more relevant MySQL 8.0.22 compressed package installation and configuration content, 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!