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
0 Comments