mysql-8.0.15-winx64 uses the zip package to install and the service is shut down immediately after starting

The MySQL version used in this example is mysql-8.0.15-winx64

1. Download the zip package

Official website address: https://dev.mysql.com/downloads/mysql/

2. Installation

After decompression, copy the decompressed files to the installation directory you prefer, for example, I like to install it in the C drive, as shown in the figure:

The files circled in red in the figure need to be manually added. The text content is: (can be changed according to actual needs)

[mysql]
# Set the default character set of the mysql client to default-character-set=utf8
 
[mysqld]
# Set port 3306 port = 3306
# Set the installation directory of mysql basedir=C:\allSoftCjy\mysql-8.0.15-winx64
# Set the storage directory of mysql database data datadir=C:\allSoftCjy\mysql-8.0.15-winx64\data
# Maximum number of connections allowed max_connections=20
# The default character set used by the server is the 8-bit latin1 character set character-set-server=utf8
# The default storage engine that will be used when creating a new table default-storage-engine=INNODB
#To copy the master-slave database data# Open the binary log log-bin=mysql-bin
# Set server-id 
server-id=1

3. Configure environment variables

4. Install MySQL

(1) Run cmd as an administrator

(2) Execute the command in the bin directory of the MySQL installation directory:

After the execution is complete, the initial default password of the root user will be printed, for example:

4. Uninstall MySQL

5. The Mysql service in Windows system is shut down immediately after startup

(1) First check the log and select the file ending with err

(2) Comment out the configuration in the box.

Summarize

The above is the introduction of mysql-8.0.15-winx64 using zip package for installation and the problem of shutting down immediately after the service is started. I hope it will be helpful to everyone. If you have any questions, please leave me a message and I 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!