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

1 download

Address: https://dev.mysql.com/downloads/mysql/

2 extract to the directory

3 configuration

Create a new txt document, save it as my.ini, and put it in the MySQL directory

[mysql] # set mysql client default character set default-character-set=utf8 [mysqld] # set port 3306 port = 3306 # set mysql installation directory basedir=D:\ Program Files\ mysql-5.7.21-winx64 # set mysql database data storage directory datadir=D:\ Program Files\ mysql-5.7.21-winx64\ data # maximum number of connections allowed max_connections=200 # the character set used by the server defaults to 8 Bit-encoded latin1 character set character-set-server=utf8 # the default storage engine default-storage-engine=INNODB that will be used when creating new tables

Note: the path of basedir and datadir is the path where your mysql is stored.

4 add the bin directory to the path environment variable

5 install the MySQL service

Execute mysqld install

If xxx.dll is missing, please install the Microsoft Runtime

6 generate data directory (MySQL 5.7.16 does not provide data directory by default)

You need to enter the bin directory first.

Run mysqld-- initialize-insecure-- user=mysql

There will be no prompt after running.

Check whether the contents of the data directory are correct

7 run the MySQL service

Net start mysql

The command to turn off the MySQL service is net stop mysql

8 log in to MySQL

Mysql-u root-p

Summary

The above is the installation of the free installation version of mysql-5.7.21-winx64 introduced by the editor-the detailed explanation of the Windows tutorial. 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!

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.