MySQL 5.7.21 winx64 installation and configuration method graphic tutorial

This article summarizes the notes for installing MySQL 5.7.21 and shares them with you

1. Unzip the downloaded MySQL compressed package to the installation directory

2. Create a new file

my.ini, placed in the mysql installation directory, the content is as follows:

[mysql] 
# Set the default character set of the mysql client to default-character-set=utf8 
[mysqld] 
#Set port 3306 port = 3306 
# Set the installation directory of mysql basedir=F:\work office\mysql-5.7.21\mysql-5.7.21-winx64 
# Set the storage directory of mysql database data datadir=F:\work office\mysql-5.7.21\mysql-5.7.21-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 

3. Install MySQL service

Open the cmd window as an administrator, switch the directory to the bin directory under the MySQL installation folder and execute mysqld install

4. Initialize the MySQL database and enter "mysqld --initialize --user=root --console". The red text below is the root password after initialization

5. Start the mysql service

6. Use the generated password to log in to MySQL and change the password by "set password=password('123456')". Here, set the root password to 123456

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

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.