MySQL 5.7.29 + Win64 decompression version installation tutorial with pictures and text

Download the official website

Choose the version that suits you to download.

Click Download and select No thanks, just start my download

Configuration

Unzip the downloaded file and put it in a disk on our computer

Configuration variables

After unzipping the file, you need to configure some variables.

Add the unzipped bin path to Path

Check whether the addition is successful

Run cmd as an administrator, enter mysql and press Enter. If prompted ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
If the command is not an internal or external command, you need to recheck the steps and try again.

Create a configuration file

Create a configuration file my.ini in the root directory of MySQL

Configuring the my.ini file

[mysqld]
#Port number port = 3306
#mysql-5.7.29-winx64 path basedir=D:\mysql-5.7.29-winx64
#mysql-5.7.29-winx64 path + \data
datadir=E:\mysql-5.7.29-winx64\data
#Maximum number of connections max_connections=200
#Encoding character-set-server=utf8
default-storage-engine=INNODB
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[mysql]
#Encoding default-character-set=utf8

Modify the paths of basedir and datadir according to your own situation

Install MySQL

Run cmd as administrator . It must be done in administrator mode! ! ! Otherwise, during the installation process, the error "Install/Remove of the Service Denied!" will appear due to insufficient administrative privileges. This is very important!
1. Enter the installation command: mysqld -install

2. Enter the initialization command: mysqld --initialize

3. Start the MySQL service: net start mysql

4. Enter MySQL: mysql -u root -p
No need to enter a password, just press Enter

5. Enter the database: use mysql

6. Enter the command to change the password: update update user set authentication_string = password("******") where user ="root"; replace ***** with the password you want to set.

Summarize

This is the end of this article about the detailed graphic and text tutorial of MySQL 5.7.29 + Win64 decompression version installation tutorial. For more relevant mysql5.7.29 decompression version installation content, please search 123WORDPRESS.COM's previous articles or continue to browse the following related articles. I hope everyone will support 123WORDPRESS.COM in the future!