• notice
  • Congratulations on the launch of the Sought Tech site

MySQL5.7.21 Decompression Edition Installation Configuration Method Graphic Tutorial (Win10)

mysql 5.7.21 Unzip version 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. Unzip the file

Decompress directly, and 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 into the directory you want to put, the following is the directory I put

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

 

  .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

Pay attention to two places:

  

This path is the path you put in step 3.

5. Configure environment variables

Open the control panel and select "Advanced System Settings"

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

 

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

 

6. MYSQL installation

"Microsoft key+Q" open 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 Root account password

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

After mysql restarts, you can directly use mysql -u root -p to enter (the password is empty 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), restart mysql
   At this time, you can use mysql -u root -p root to enter

Remarks:

The following errors may be encountered during the installation process:

The MySQL service could not be started.

The service did not report any errors.

Please type NET HELPMSG 3534 for more help.

 

Processing:

Check if data exists in the MYSQL directory and reinstall.

 

 Enter sc delete mysql to delete the original MYSQL  Repeat step 6

Articles you may be interested in:

  • MySQL5.7.21 installation and password graphic configuration tutorial
  • Detailed installation process of mysql5.7.21 under win10
  • Detailed tutorial of mysql5.7.21 installation under Windows system
  • Graphic tutorial of mysql 5.7.21 installation and configuration method (window)
  • mysql5.7.21 installation and configuration tutorial
  • mysql 5.7.21 winx64 installation and configuration method graphic tutorial
  • mysql5.7.21.zip installation tutorial
  • Detailed steps to install MySql 5.7.21 in Linux
  • mysql 5.7.21 winx64 free installation version configuration method graphic tutorial

Tags

Technical otaku

Sought technology together

Related Topic

0 Comments

Leave a Reply

+