Mysql5.7.19 winx64 installation and configuration method graphic tutorial (win10), winx64win10

Mysql5.7.19 winx64 installation and configuration method graphic tutorial (win10), winx64win10

The following is a record of the mysql 5.7.19 winx64 installation tutorial.

Step 1

Https://dev.mysql.com/downloads/mysql/

Select manual download version

Decompress the package to the specified path.

 

The my. ini and data folders in are not found in the compressed package, and you need to add them yourself later.

My. iniCopy directly ~

[Client] port = 3306default-character-set = utf8 [mysqld] # Set to your own MYSQL installation directory basedir = D: \ Mysql \ mysql-5.7.19-winx64 # Set to mysql data directory datadir = D: \ Mysql \ mysql-5.7.19-winx64 \ dataport = 3306character_set_server = utf8sql_mode = NO_ENGINE_SUBSTITUTION, NO_AUTO_CREATE_USER # enable query cache fig _ defaults_for_timestamp = trueskip-grant-tables

Create a data folder under the Directory

Step 2

Set Environment Variables
Computer> Properties> Advanced System Properties> Environment Variables
Create in Path of system variable (% MYSQL installation directory % \ bin)

Step 3

Go to the bin folder under the Mysql installation directory, whereOpen cmd as an administrator

Execute mysqld-initialize-insecure

This command is used to make the data directory have a normal mysql folder and related files.

IfError:Found option without preceding group in config file: D: \ mysql\ mysql-5.7.19-winx64 \ my. ini at line: 1

The solution is to save my. ini in ANSI format.

Then execute the following commands (Administrator mode) in sequence ):

mysqld install net start mysql

If you need to change the password, enter:

set password for root@localhost = password(‘123456');

Step 4

Finished ~
Try mysql-u root-p login ~

Highlights: mysql installation tutorials for different versions mysql5.7 installation tutorials for various versions mysql5.6 installation tutorials

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.