MySQL 5.7.21 winx64 free installation version configuration method graphic tutorial

MySQL 5.7.21 winx64 free installation version configuration method, for your reference, the specific content is as follows

1. Download

Click to download link

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

https://www.jb51.net/softs/69599.html

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

Wonderful topic sharing: Installation tutorials for different versions of MySQL Installation tutorials for MySQL 5.7 versions Installation tutorials for MySQL 5.6 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.