The latest mysql-5.7.21 installation and configuration method

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

2. Create a new file my.ini and place it 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 the 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

Summarize

The above is the installation and configuration method of mysql-5.7.21 introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!