MySQL 5.7 zip version (zip version) installation and configuration steps detailed

Preface: I reinstalled win10 and organized the files at the same time. However, it took me an entire afternoon to install MySQL, which was really not worth it, so I wrote this article to help everyone.

1. Download

https://dev.mysql.com/downloads/mysql/

2. Unzip the zip package

3. Configure environment variables

(1) Configuring Path

(2) Modify the mysql-default.ini configuration file

Original:

# These are commonly set, remove the # and set as required.# basedir = .....# datadir = .....# port = .....# server_id = .....

Modified:

4. Enter the command prompt cmd as an administrator

Note: First, run mysqld -install, then mysqld –initialize

(1) Execute mysqld -install

C:\Users\donald>cd D:\tools\developer\MySQL\mysql-5.7.17-winx64\binC:\Users\donald>d:D:\tools\developer\MySQL\mysql-5.7.17-winx64\bin>mysqld -installService successfully installed. //Successful installation of the service

(2) Execute mysqld –initialize

D:\tools\developer\MySQL\mysql-5.7.17-winx64\bin>mysqld --initialize D:\tools\developer\MySQL\mysql-5.7.17-winx64\bin>

The data folder will be created automatically

(3)mysqld.exe -nt –skip-grant-tables (Note: the window does not respond)

D:\tools\developer\MySQL\mysql-5.7.17-winx64\bin>mysqld.exe -nt --skip-grant-tables

(4) Close the window directly and then reopen DOS (also open as an administrator)

mysql> update user set authtication_string=Password('admin') where user="root"; mysql> create a new authtication_string with root user="root"; mysql> create a new authtication_string with root user="root"; mysql> create a new authtication_string with root user="root"; mysql> create a new authtication_string with root user="root"; mysql> create a new authtication_string with root user="root"; mysql> create a new authtication_string with root user="root"; mysql> create a new authtication_string with root user="root"; mysql> create a new authtication_string with root user="root"; mysql> create a new authtication_string with root user="root"; mysql> create a new authtication_string with root user="root"; mysql> create a new authtication_string with root user="root"; mysql> create a new authtication_string with root user="root"; mysql> create a new authtication_string with root user="root"; mysql>flush privileges; 0 rows affected (0.01 sec)

5. Verification successful

(1) Terminate the mysqld process in the Task Manager and start the mysql service

C:\Users\donald>net start mysql

If it appears:

Open Task Manager, find mysqld, and end the process.

Then restart mysql and it will work.

(2) Enter mysql -u root -p

C:\Users\donald>mysql -u root -p //Enter admin

The above is the detailed installation and configuration steps of MySQL 5.7 zip version (zip version) introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!

You may also be interested in:

How to install and uninstall MySQL service under Windows (MySQL 5.6 zip decompression version installation tutorial)
Detailed installation tutorial of mysql-8.0.11-winx64.zip
Detailed installation steps for MySQL 5.7.17 decompressed version (ZIP version)
mysql5.7.13.zip installation tutorial (windows)
MySQL 5.6.51 decompressed version (zip version) installation and configuration graphic method
MYSQL ZIP installation-free version configuration steps and graphical management tool mysql-workbench
Detailed process of decompressing and installing mysql5.7.17 zip
MySQL 5.5.x zip direct decompression version installation method
mysql8.0.0 winx64.zip decompression version installation and configuration tutorial
Solution to the problem of installing MySQL compressed version zip

<<: How to control the startup order of docker compose services

>>: Learn asynchronous programming in nodejs in one article