Mysql-5.7.18-winx64 compressed version installation configuration

Mysql-5.7.18-winx64 installation Configuration

First, configure the MY.CNF

1, decompression mysql-5.7.18-winx64.zip to the e-packing directory

650) this.width=650; "Src=" https://s4.51cto.com/wyfs02/M01/96/34/wKiom1keSgDTObmKAAEenPQkF_4760.png-wh_500x0-wm_ 3-wmp_4-s_2639712183.png "title=" As.png "alt=" Wkiom1kesgdtobmkaaeenpqkf_4760.png-wh_50 "/>

2. Write My.cnf file

Create the my-small.cnf file and put it under the MySQL root directory.

[Client]

Default-character-set=utf8

[MySQL]

Default-character-set=utf8

[Mysqld]

port=3306

Basedir=e:/mysql-5.7.18-winx64

Datadir=e:/mysql-5.7.18-winx64/data

Character_set_server=utf8

init_connect= ' SET NAMES UTF8 '

Collation-server=utf8_general_ci

Skip-character-set-client-handshake

Sql_mode=no_engine_substitution,strict_trans_tables

Second, the initial installation of MYSQL5 services

1. Delete Service: SC delete mysql57

2. Stop service: net stop MYSQL5

3, installation command: mysqld--install mysql57--defaults-file= "E:\mysql-5. 7.18-winx64\my-small.cnf "

4. Initialization: Mysqld--initialize-insecure

Third, start and change the password

1. Start MySQL service: net start mysql57

2, Login: mysql-uroot-p

3, change the password:

Use MySQL;

Update user set Authentication_string=password (' Leizm '), host= '% ' where user= ' root ';

Flush privileges;

Quit

4, re-login: Mysql–uroot–pleizm

Iv. installation and configuration of MySQL client tools

Windows under Client tools: SQLyog Enterprise 11.52

650) this.width=650; "Src=" https://s3.51cto.com/wyfs02/M01/96/34/wKioL1keSizyZOztAAE9yWTpN6Q415.png-wh_500x0-wm_ 3-wmp_4-s_1854042524.png "title=" As.png "alt=" Wkiol1kesizyzoztaae9ywtpn6q415.png-wh_50 "/>

V. Common operation of MySQL client tools

Vi. SQL Practice

This article is from the lava blog, so be sure to keep this source http://lavasoft.blog.51cto.com/62575/1927387

Mysql-5.7.18-winx64 compressed version installation configuration