Mysql 5.7.21 winx64 installation and configuration method graphic tutorial, 5.7.21winx64

Mysql 5.7.21 winx64 installation and configuration method graphic tutorial, 5.7.21winx64

This article summarizes the notes for installing mysql5.7.21 and shares them with you.

1. decompress the downloaded mysql package to the installation directory.

2. Create a file

My. ini, placed in the mysql installation directory, the content is as follows:

[Mysql] # set the default character set of the mysql client default-character-set = utf8 [mysqld] # set port 3306 = 3306 # set the mysql installation directory basedir = F: \ work office \ mysql-5.7.21 \ mysql-5.7.21-winx64 # Set the data storage directory for the mysql database datadir = F: \ work office \ mysql-5.7.21 \ mysql-5.7.21-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 # when creating a new table default-storage-engine = INNODB

3. Install the mysql Service

Open the cmd window as an administrator and switch the directory to the bin directory under the mysql installation folder.
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 on to mysql and use "set password = password ('000000')" to change the password. Set the root password to 123456.

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