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

This article records the installation and configuration method of mysql 5.7.16. The details are as follows.

Step 1: download

Download address

Scroll below and you can see it and download it according to your own needs.

My computer is 64, so the download is Windows (x86, 64-bit), ZIP Archive.

Just download it and unzip it to where you want to put it.

Step 2: configure

1. Configure the bin folder of the root directory into the path environment variable (Baidu if you don't know)

Mine is: d:\ Program Files\ mysql-5.7.16-winx64\ bin just configure to the environment variable.

2. Modify or copy a my-default.ini file and rename it my.ini

If the path contains\ s, it needs to be replaced.

Add the following code:

[mysql] # set mysql client default character set default-character-set=utf8 [mysqld] # set port 3306 port = 3306 # set mysql installation directory basedir=D:\ ProgramFiles\ mysql-5.7.21-winx64# set mysql database data storage directory datadir=D:\ ProgramFiles\ mysql-5.7.21-winx64\ data # maximum number of connections max_connections=200 # the character set used by the server defaults to 8 bits Encoded latin1 character set character-set-server=utf8 # default storage engine default-storage-engine=INNODB to use when creating new tables

3. Enter at the command prompt

Mysqld-install MySQL-defaults-file= "my.ini"

Install mysql and set "my.ini" as the configuration file. Prompt "Service successfully installed." Indicates success

4. Enter at the command prompt

Mysqld-initialize

Initialize the data directory first, which is not required in versions prior to 5.7. initialize the data directory first. After successful initialization, you will find that there is an extra data folder in the root directory.

5. Enter net start MySQL to start mysql at the command prompt to prompt the service to start successfully

Wonderful topic sharing:

Installation tutorials for different versions of mysql

Installation tutorials for each version of mysql5.6

Installation tutorials for each version of mysql5.7

Installation tutorials for each version of mysql8.0

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.

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.