MySQL 5.7.21 decompression version installation and configuration graphic tutorial

This article records the detailed process of downloading and installing the decompressed version of MySQL 5.7.21 for your reference. The specific contents are as follows

1. First, unzip the MySQL version and download it from https://www.mysql.com/downloads/;

2. Unzip the installation package and choose the path according to your preference. The path I chose is E:\Java\java\MySQL, so the full path is E:\Java\java\MySQL\mysql-5.7.21-winx64

3. Configure environment variables

Add new system environment variables:

Key name: MYSQL_HOME

The value is: E:\Java\java\MySQL\mysql-5.7.21-winx64

Add in Path: %MYSQL_HOME%\bin. Note that the ";" symbol between different values ​​in Path cannot be omitted.

4. Prepare the my.ini file . You can create a new my.txt file first, and then rename the file to .ini. The previous version may have a my-default.ini file after decompression, but the 5.7.21 version does not have it, so you need to create the file manually. The content of the file is as follows:

[mysql] 
# Set the default character set of the mysql client to default-character-set=utf8 
[mysqld] 
#Set port 3306 port = 3306 
# Set the installation directory of mysql basedir=E:\Java\java\MySQL\mysql-5.7.21-winx64 
# Set the storage directory of mysql database data datadir=E:\Java\java\MySQL\mysql-5.7.21-winx64\data 
# Maximum number of connections allowed max_connections=200 
# The default character set used by the server is the 8-bit latin1 character set character-set-server=utf8 
# The default storage engine that will be used when creating a new table default-storage-engine=INNODB

Put the edited my.ini file in the E:\Java\java\MySQL\mysql-5.7.21-winx64 directory

5. Open the cmd command window as an administrator and switch the directory to the bin directory of the MySQL installation directory

6. Execute the following statement to install MySQL

mysqld -install

After executing the command, the prompt: Service successfully installed. indicates that the installation is successful

7. Execute the following statement to initialize MySQL

mysqld --initialize-insecure --user=mysql

After executing the command, a data directory will be generated under the MySQL installation directory and a root user will be created.

8. Execute the following command to start the mysql service

net start mysql

After execution, the following prompt will appear:

MySQL service is starting..

The MySQL service has been started successfully.

9. After starting MySQL, the root user's password is blank. Set the password with the following command:

mysqladmin -u root -p password new password
Enter password: Old password

When you need to enter the old password, since the old password is empty, just press Enter.

The decompressed version of MySQL 5.7.21 has been installed.

Wonderful topic sharing:

MySQL different versions installation tutorial

MySQL 5.7 installation tutorials for various versions

MySQL 5.6 installation tutorials for various versions

mysql8.0 installation tutorials for various versions

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.