Shulou(Shulou.com)06/01 Report--

This article shares the mysql 5.7 zip archive version installation tutorial for your reference, the specific contents are as follows

1. Download zip archive version from official website: official website address

2. Extract to the appropriate directory and configure environment variables (add *\bin to path);

3. (Important) Create a new my.ini file in the root directory and write the following:

[mysql]#Set mysql client default character set default-character-set=utf8[mysqld]#Set port 3306 port = 3306 #Set mysql installation directory basedir=D:\Database\MySQL Server 5.7#Set mysql database data storage directory datadir=D:\Database\MySQL Server 5.7\data#Maximum connections allowed max_connections=200#Character set used by server default 8-bit encoded latin1 character set character-set-server=utf8#Default storage engine to be used when creating new tables default-storage-engine=INNODB #Skip password validation #skip-grant-tables

4. Run cmd (remember to use administrator status);

5. (Important) Execute command mysqld --initialize

##This step is very important, because the previous version can install the service directly by executing the install command. After 5.7, it is necessary to initialize the database file (data file under the root directory), otherwise the service cannot be started later;

6. Execute the command mysqld install to install the service;

7. Execute the command net start mysql to start services;(stop services net stop mysql)

8. Execute the command mysql -uroot -p, error 1045(28000) will be reported, login password needs to be set;

9. Open the configuration file my.ini, remove the #in front of skip-grant-tables, restart the service, and log in again to skip the password;

10. Enter the mysql database and execute the following commands:

use mysql;update user set authentication_string=password("root") where user="root";flush privileges;quit;

11. Open the configuration file my.ini, add #comment before skip-grant-tables, then restart the service and log in again with the set password;

12. Enter the command show databases and report ERROR 1820 (HY000);

13. set password=password("root");

14. The installation is complete;

Excellent topic sharing:

mysql different versions installation tutorial

mysql5.6 installation tutorial

mysql5.7 installation tutorial

mysql8.0 installation tutorial

The above is all the content of this article, I hope to help everyone's study, but also hope that everyone a lot of support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.