Shulou(Shulou.com)06/01 Report--

The version of mysql 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 unzipping, copy the extracted files to your preferred installation directory, for example, I like to be under disk C, as shown in the figure:

The files circled in red boxes on the figure need to be manually created and added by yourself. The text content is as follows: (can be changed according to actual needs)

[mysql] # set mysql client default character set default-character-set=utf8 [mysqld] # set port 3306 port = 330 setting mysql installation directory basedir=C:\ allSoftCjy\ mysql-8.0.15-winx64# set mysql database data storage directory datadir=C:\ allSoftCjy\ mysql-8.0.15-winx64\ data# maximum number of connections the character set used by the max_connections=20# server defaults to 8 bits Code latin1 character set character-set-server=utf8# the default storage engine default-storage-engine=INNODB# that will be used when creating a new table in order to copy master-slave database data # turn on binary log log-bin=mysql-bin# setting server-id server-id=1

3. Configure environment variables

4. Install mysql

(1) run cmd as an administrator

(2) execute the command under the bin directory of the MySQL installation directory:

When the execution is complete, the initial default password for the root user is printed, such as:

4. Uninstall mysql

5. The problem of shutting down immediately after starting the Mysql service in windows system

(1) first check the log and select the file ending in err

(2) comment out the configuration in the box.

Summary

The above is the problem that the editor introduces to you that mysql-8.0.15-winx64 uses zip package to install and shut down immediately after the service starts. I hope it will be helpful to you. If you have any questions, please leave me a message and the editor will reply to you in time. Thank you very much for your support to the website!

If you think this article is helpful to you, you are welcome to reprint it, please indicate the source, thank you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.