MySQL 5.7.17 installation graphic tutorial (windows)

I recently started learning database, and I feel it is a very interesting course, but many of the things involved are new to me, so I want to organize my study notes here. The first thing to sort out is the installation and configuration methods of DBMS MySQL used in the course.

Download

>>> MySQL 5.7 Downloads

Select the corresponding machine and bit number, and click Download.

Unzip and configure

1. Unzip the downloaded MySQL compressed package.

2. Modify the configuration file:

Copy and paste the following text into the my.txt file, change the suffix of my.txt to .ini and replace it with the configuration file (my-default.ini) in the original MySQL installation 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:\MySql\mysql-5.7.12-winx64
  # Set the storage directory of mysql database data datadir=D:\MySql\mysql-5.7.12-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 specific paths of basedir and datadir should be filled in according to the actual installation path. Install

1. Enter the bin directory and start installing MySQL:

2. Initialize (create data directory), enter in the command line:
mysqld --initialize

3. To install, enter in the command line:
mysqld install

4. Start the service and enter in the command line:
net start mysql
In addition, the command to shut down the service is:
net stop mysql

5. Create a user password:
mysql -uroot -p
Enter the password after pressing Enter

Environment variables

In order to avoid switching directories every time in cmd, we add the MySQL bin directory to the Path environment variable:

At this point, the installation and configuration of MySQL has been completed.

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.