MySQL 8.0.20 compressed version installation tutorial with pictures and text

1. MySQL download address;
http://ftp.ntu.edu.tw/MySQL/Downloads/MySQL-Cluster-8.0/
2. After decompression, put it in a folder and create a my.ini configuration file;

my.ini file content:

[mysqld]

character-set-server=utf8

bind-address = 0.0.0.0

port = 3306
#Configure the decompression path of mysql, you need to manually change basedir=D:\installtools\mysql-8.0.20-winx64
#Configure the database location of mysql. If there is no datas folder, you need to create it manually and change the path to datadir=D:\installtools\mysql-8.0.20-winx64\datas

max_connections=2000

default-storage-engine=INNODB
#Since the new version of MySQL does not support the default commands of the old version, you need to add this configuration default_authentication_plugin=mysql_native_password

[mysql]
default-character-set=utf8
[mysql.server]
default-character-set=utf8

[client]
default-character-set=utf8

Configure environment variables, and add the path of the unzipped bin directory to the path; right-click My Computer Properties → Advanced System Settings → Environment Variables; after configuration, confirm in sequence and the configuration is complete;

3. Run cmd with administrator privileges in the unzipped bin path and run the mysqld --install command;

4. After the above prompt is successful, run: mysqld --initialize --user=root --console command initialization password, the red box below

5. Execute the net start mysql command to start the MySQL service:

6. After successfully starting the MySQL service, execute: mysql -u root -p, and then enter the default password just obtained

7. Modify the default password command: ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Enter the modified password'; for example, change it to: 123456; enter exit to exit mysql

Summarize

This is the end of this article about the installation tutorial of MySQL 8.0.20 compressed version. For more relevant MySQL 8.0.20 compressed version installation 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!