mysql5.7.19 winx64 installation and configuration method graphic tutorial (win10)

The installation tutorial of mysql 5.7.19 winx64 is recorded as follows and shared with everyone

step1

Official download address: https://dev.mysql.com/downloads/mysql/

Select Manual Download Version

Unzip to the path you specify

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

my.ini is as follows, just copy~

[client]
port=3306
default-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\data
port=3306
character_set_server=utf8
sql_mode=NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER
# Enable query cache explicit_defaults_for_timestamp=true
skip-grant-tables

Then create a data folder in the directory

Step 2

Set environment variables <br /> Computer->Properties->Advanced System Properties->Environment Variables Create a new path in the system variables (%MYSQL installation directory%\bin)

Step 3

Enter the bin folder under the MySQL installation directory and open cmd as an administrator here

Execute mysqld –initialize-insecure

This command is to ensure that there are normal mysql folders 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 commands in sequence (administrator mode):

mysqld install 
net start mysql

If you need to change the password, enter:

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

Step 4

Finished~
Try logging in with mysql -u root -p ~

Wonderful topic sharing: Installation tutorials for different versions of MySQL Installation tutorials for MySQL 5.7 versions Installation tutorials for MySQL 5.6 versions

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.