MySQL 8.0.16 compressed version download and installation tutorial under Win10 system

Download from official website: https://www.mysql.com

Go to the MySQL official website and select download

Select Community

Choose MySQL Community Server

Click download

Click the bottom to download without logging in

The download is completed as a compressed package

Install

Unzip the file

Add the bin file directory to the computer system environment configuration path

Create a new my.ini configuration file

[mysql]
default-character-set = utf8
[mysqld]
#Port port = 3306
#mysql installation directory basedir = E:/mysql-8.0.16-winx64
#mysql data storage directory datadir = E:/mysql-8.0.16-winx64/data
#Maximum number of connections allowed max_connections = 1024
#The number of allowed connection failures max_connect_errors=10
#The server uses the character set character-set-server = utf8 by default
#Default storage engine default-storage-engine = INNODB

Open cmd as administrator

Enter the mysql->bin directory

Here, the default password is empty to initialize the database

Enter the command: mysqld --initialize-insecure

Install MySQL: mysqld install

If mysql has been installed before, the following error may occur

The previous mysql service needs to be removed

Type: mysqld -remove MySQL

Install again

Start MySQL: net start mysql

Enter MySQL: mysql -u root -p

Because the password is initialized to empty, enter the password and press Enter to enter mysql

Encountering a problem

Time zone error when project connects to database

java.sql.SQLException: The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.

This error is usually caused by using version 8.0 of the database and version 8.0 of the mysql-connector-java driver. You need to add the time zone parameter in the URL to connect to the database.

serverTimezone=GMT%2B8 GMT%2B8 represents the East 8th zone

Original url: jdbc:mysql://localhost:3306/test

Add parameter: jdbc:mysql://localhost:3306/test?serverTimezone=GMT%2B8

Or directly change the database time zone settings:

show variables like '%time_zone%' ;

set global time_zone='+8:00';

Summarize

The above is the illustrated tutorial for downloading and installing the compressed version of MySQL8.0.16 under Win10 system introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!
If you find this article helpful, please feel free to reprint it and please indicate the source. Thank you!