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

This article is mainly about the detailed operation of mysql-5.7.18-winx64 installation and configuration, if you are interested, let's take a look at this article. I believe it is of some reference value to you after reading the detailed operation of mysql-5.7.18-winx64 installation and configuration.

1. Configure my.cnf

1. Decompress the mysql-5.7.18-winx64.zip to the root directory of the E disk

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

Initialize and install the mysql5 service

1. Delete service: sc delete mysql57

2. Stop the service: net stop mysql5

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

4. Initialize: mysqld-- initialize-insecure

Third, start and change the password

1. Start the mysql service: net start mysql57

2. Log in: mysql-uroot-p

3. Change password:

Use mysql

Update user set authentication_string=password ('leizm'), host='%' where user='root'

Flush privileges

Quit

4. Log in again: mysql-uroot-pleizm

IV. Installation and configuration of MySQL client tools

Client tools under Windows: Sqlyog Enterprise 11.52

The above details about the installation and configuration of mysql-5.7.18-winx64 are helpful to everyone. If you want to know more about it, you can continue to follow our industry information section.

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.