Mysql 5.7.17 installation graphic tutorial (windows), mysql5.7.17

Mysql 5.7.17 installation graphic tutorial (windows), mysql5.7.17

I recently started to study databases. It seems to be a very interesting course, but many of the things involved are the first time I came into contact. I want to sort out the study notes here. The first step is to sort out the DBMS MySQL installation and configuration methods used in the course.

>>> MySQL 5.7

Select the desired machine and number of digits, and click Download.

Decompression and Configuration

1. decompress the downloaded MySQL package.

2. modify the configuration file:

Paste the following text copy to the my.txt file, modify my.txt suffix to. ini and replace it with the configuration file (my-default.ini) under the original MySQL installation directory ).

[Mysql] # set the default character set of the mysql client default-character-set = utf8 [mysqld] # set port 3306 to port 3306 # set the mysql installation directory basedir = D: \ MySql \ mysql-5.7.12-winx64 # Set the mysql database data storage directory datadir = D: \ MySql \ mysql-5.7.12-winx64 \ data # maximum number of connections allowed max_connections = 200 # the character set used by the server defaults to the 8-bit latin1 character set character-set-server = utf8 # default storage engine default-storage-engine = INNODB

Note:The path of basedir and datadir must be set according to the actual installation path.Install

1. Go to the bin directory and start MySQL installation:

2. initialize (create a data directory) and enter the following in the command line:
Mysqld -- initialize

3. Install the SDK by entering the following command in the command line:
Mysqld install

4. Start the service and enter:
Net start mysql
In addition, the command to disable the service is:
Net stop mysql

5. Create a user password:
Mysql-uroot-p
Enter the password after you press Enter.

Environment Variable

To make it easier to switch directories in cmd without having to do so, we add the bin directory of MySQL to the Path environment variable:

By now, MySQL installation and configuration have been completed.

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.