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

This article records the mysql 5.7.23 winx64 installation tutorial, which is as follows

Step1

Official: download address

Choose to download the version manually

Extract to the path specified by yourself

The my.ini and data folders in the above figure are not available in the package. You need to add them later.

My.ini is as follows, direct copy~

[client] port=3306default-character-set=utf8 [mysqld] # set to the installation directory of your MYSQL basedir=D:\ Mysql\ mysql-5.7.23-winx64# to the data directory of MYSQL datadir=D:\ Mysql\ mysql-5.7.23-winx64\ dataport=3306character_set_server=utf8sql_mode=NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER# enable query cache explicit_defaults_for_timestamp=trueskip-grant-tables

Then create a data folder under the directory

Step2

Set environment variabl

Computer-> Properties-> Advanced system Properties-> Environment variables

Create a new (% MYSQL installation directory%\ bin) in Path in the system variable

Step3

Go to the bin folder under the Mysql installation directory and open cmd as an administrator here

Execute mysqld-initialize-insecure

The purpose of this command is to have a normal mysql folder and related files in the data directory.

If error:Found option without preceding group in config file: d:\ Mysql\ mysql-5.7.19-winx64\ my.ini at line: 1 appears

The solution is to save my.ini in ANSI format

Then execute the following command (administrator mode) in turn:

Mysqld install net start mysql

If you need to change your password, enter:

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

Step4

Finished ~

Mysql-u root-p login try ~

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.