MySQL 5.7.21 decompression version installation and configuration method graphic tutorial (win10)

The installation and configuration method of MySQL 5.7.21 decompressed version is for your reference. The specific contents are as follows

1. Download the MYSQL compressed file from the official website.

Download URL

2. Unzip the file

Decompress directly. The installation package directory after decompression is as follows: (Note: there is no data directory and .Ini file at this time)

3. Put the file in the directory you want. Here is the directory I put it in

4. Since there is no .ini file after decompression, create a new my.ini file in this directory

The .ini file content is as follows:

[mysqld]
port = 3306
basedir=C:\Program Files\MYSQL\MySQL Server 5.7.21
datadir=C:\Program Files\MYSQL\MySQL Server 5.7.21\data 
max_connections=200
character-set-server=utf8
default-storage-engine=INNODB
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[mysql]
default-character-set=utf8

Note two things:

This path is the path you placed in step 3.

5. Configure environment variables

Open the Control Panel and select "Advanced System Settings"

In the pop-up tab, select "Advanced" and then select "Environment Variables"

Create a new "MYSQL_HOME" value in the system variables "C:\Program Files\MYSQL\MySQL Server 5.7.21" (the path stored in step 3)

6. MYSQL Installation

"Microsoft key + Q" opens the search CMD

Run Command Prompt as an administrator.

Enter the MYSQL directory cd C:\Program Files\MYSQL\MySQL Server 5.7.21\bin

Run mysqld --initialize

Run mysqld -install

Run net start mysql to start the service

7. Set the root account password

Modify the MySQL configuration file (my.ini) and add a line of skip-grant-tables under [mysqld]

After mysql is restarted, you can directly enter it using mysql -u root -p (the password is empty at this time);

Enter update mysql.user set authentication_string=password("root") where user="root";

Enter flush privileges;

Type quit;
Restore the my.ini file (delete the skip-grant-tables line) and restart mysql
At this time, you can use mysql -u root -p root to enter

Remark:

During the installation process you may encounter the following errors:

The MySQL service cannot be started.

The service did not report any errors.

Type NET HELPMSG 3534 for more help.

deal with:

Check whether the data in the MYSQL directory exists and reinstall it.

Enter sc delete mysql to delete the original MYSQL and repeat step 6

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.