MySQL 5.7.23 winx64 installation and configuration method graphic tutorial under win10

This article records the installation tutorial of MySQL 5.7.23 winx64. The specific contents are as follows

Step 1

Official: Download address

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.23-winx64
# Set to MYSQL data directory datadir=D:\Mysql\mysql-5.7.23-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

Setting Environment Variables

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~

mysql -u root -p login try~

Wonderful topic sharing:

MySQL different versions installation tutorial

MySQL 5.6 installation tutorials for various versions

MySQL 5.7 installation tutorials for various versions

mysql8.0 installation tutorials for various 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.