mysql-5.7.21-winx64 free installation version installation--Windows tutorial detailed explanation

1 Download

The address is: https://dev.mysql.com/downloads/mysql/

2 Unzip to a directory

3 Configuration

Create a new txt document, save it as my.ini, and put it in the MySQL directory

[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=D:\Program Files\mysql-5.7.21-winx64 
# Set the storage directory of mysql database data datadir=D:\Program Files\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

Note: The paths of basedir and datadir are the paths where your mysql is stored

4 Add the bin directory to the path environment variable

5 Install MySQL Service

Execute mysqld install

If "Missing xxx.dll, please install the Microsoft runtime

6 Generate a data directory (MySQL 5.7.16 and later does not provide a data directory by default)

First enter the bin directory

Run mysqld --initialize-insecure --user=mysql

There will be no prompt after running

Check whether the contents of the data directory are correct

7. Run MySQL Service

net start mysql

The command to shut down the MySQL service is net stop mysql

8 Log in to MySQL

mysql -u root –p

Summarize

The above is the detailed installation of mysql-5.7.21-winx64 free installation version--Windows tutorial 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!