Mysql5.7.21.zipinstallation tutorial, mysql5.7.21.zip

Mysql5.7.21.zipinstallation tutorial, mysql5.7.21.zip

The detailed installation process of mysql5.7.21 zip is as follows:

1. decompress the package to the specified drive D: \ mysql-5.7.21-winx64

2. Create a New my. ini file in the D: \ mysql-5.7.21-winx64 folder and put the following code in the my. ini file

Modify the basedir and datadir according to your actual 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-5.7.21-winx64 # Set the mysql database data storage directory datadir = D: \ 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 # enable query cache explicit_defaults_for_timestamp = trueskip-grant -tables # default storage engine default-storage-engine = INNODB used when creating a new table

3. Configure Environment Variables

MYSQL_HOME: D: \ mysql-5.7.21-winx64

Add % MYSQL_HOME % \ bin after the system environment path, not a win10 partner, pay attention to the plus points (";")

4.open cmd.exe and run it as an administrator.

mysqld --initialize --user=mysql --console

5. Install the service

mysqld --install MySQL5.7.21 

6.

Start the service

net start MySQL5.7.21

Stop Service

net stop MySQL5.7.21

7. After logging in with the initial password, execute the following command to change the password

Set password for root @ localhost = password ('your password ');

If the password fails to be modified, run flush privileges first.

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