Mysql 5.7.21 unzip version installation and configuration method graphic tutorial (win10), 5.7.21win10

Mysql 5.7.21 unzip version installation and configuration method graphic tutorial (win10), 5.7.21win10

Mysql 5.7.21 unzip the installation and configuration method for your reference. The specific content is as follows:

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

Download URL

2. decompress the file

Directly decompress the package. The directory of the installation package is as follows: (Note: There is no data directory or. ini file)

3. Put the file in the directory you want to put. below is my directory

4. Because no. ini file is created in this directory after decompression

 

The content of the. ini file is as follows:

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

Note:

This path is the path you put in step 1.

5. Configure Environment Variables

Open Control Panel and select "Advanced System settings"

On the displayed tab, select "advanced" and select "environment variables"

 

Create the "MYSQL_HOME" value "C: \ Program Files \ MYSQL \ MySQL Server 5.7.21" in the system variable (path stored in step 1)

 

6. Install MYSQL

"Microsoft key + Q" open search CMD

Run the "command prompt" as an administrator ".

 

Go to 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 use mysql-u root-p to enter (the password is blank at this time );

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

Enter flush privileges;

Enter quit;
Restore the my. ini file (delete the skip-grant-tables line) and restart mysql.
You can use mysql-u root-p root to enter

Note:

The following errors may occur during installation:

The MySQL service cannot be started.

The Service did not report any errors.

Type net helpmsg 3534 for more help.

 

Processing:

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

 

Enter SC delete mysql to delete the original MYSQL. Repeat Step 1.

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