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

The detailed process of mysql5.7.21 zip installation is as follows

1. Unpack it and put it on the specified disk D:\ mysql-5.7.21-winx64

two。 Put the new my.ini file in the D:\ mysql-5.7.21-winx64 folder and put the following code in the my.ini file

Basedir and datadir, please modify them according to your actual installation directory

[mysql] # set mysql client default character set default-character-set=utf8 [mysqld] # set port 3306 port = 330 setting mysql installation directory basedir=D:\ mysql-5.7.21-winx64# set mysql database data storage directory datadir=D:\ mysql-5.7.21-winx64\ data# allow maximum number of connections the character set used by the max_connections=200# server defaults to 8-bit encoded latin1 characters Set character-set-server=utf8# enables query caching explicit_defaults_for_timestamp=trueskip-grant-tables# the default storage engine default-storage-engine=INNODB that will be used when creating new tables

3. Configure environment variables

MYSQL_HOME:D:\ mysql-5.7.21-winx64

Add;% MYSQL_HOME%\ bin after the system environment path. Be careful to add a semicolon (";") if you are not a partner of win10.

4. To open cmd.exe, you must run as an administrator

Mysqld-initialize-user=mysql-console

5. Installation service

Mysqld-install MySQL5.7.21

6.

Start the service

Net start MySQL5.7.21

Out of Service

Net stop MySQL5.7.21

7. After logging in with the initial password, execute the following instructions to change the password

Set password for root@localhost=password ('your password')

If you fail to change the password, please execute flush privileges; first before performing the change.

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.