MySQL 5.7.27 installation and configuration method graphic tutorial

The installation tutorial of MySQL 5.7.27 is recorded as follows and shared with everyone

Step 1: Unzip the folder:

Step 2: Configure environment variables

Step 3: Create a new my.ini file under the unzipped folder

[mysqld]
#Set port 3306 to 3306
# Set the installation directory of mysql to basedir=E:\MySQl\mysql-5.7.27-winx64
# Set the storage directory of mysql database data datadir=E:\MySQl\mysql-5.7.27-winx64\data
# Maximum number of connections allowed max_connections=200
# The default character set used by the server is the 8-bit latin1 character set character-set-server=utf8
# The default storage engine that will be used when creating a new table default-storage-engine=INNODB
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[mysql]
# Set the default character set of the mysql client to default-character-set=utf8

Step 4: Install MySQL in the DOS window:

Step 5: Set MySQL password:

Stop mysql first:

Find the my.ini file and add skip-grant-tables to any line under the mysqld field.

After completing the above commands, return to the my.ini file and delete skip-grant-tables

Wonderful topic sharing:

MySQL different versions installation tutorial

MySQL 5.7 installation tutorials for various versions

MySQL 5.6 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.