mysql 5.7.23 winx64 decompression version installation tutorial

Detailed installation tutorial of mysql-5.7.23-winx64 decompression version for your reference. The specific contents are as follows

1. Click here to download MySQL 5.7

2. Unzip the installation package: D:\workSofte\MySql\mysql-5.7.23-winx64

3. Configure the bin directory behind the environment variable path

• Create a new MYSQL_HOME variable and set the value to: D:\workSofte\MySql\mysql-5.7.23-winx64
• Edit the path system variable and add %MYSQL_HOME%\bin to the path variable. Configure the path environment variable. You can also configure the bin directory under the MySQL installation directory to the path variable directly instead of creating a new MYSQL_HOME variable. Path: %MYSQL_HOME%\bin
  

4. Prepare the my.ini file. You can first create a new my.txt file, and then rename the file suffix to .ini. The previous version may have a my-default.ini file after decompression, but the 5.7.23 version does not, so you have to create the file manually. After editing the my.ini file, put the my.ini file in the D:\workSofte\MySql\mysql-5.7.23-winx64 directory. The contents of the file are as follows:

[mysqld]
port = 3306
basedir=D:\workSofte\MySql\mysql-5.7.23-winx64
datadir=D:\workSofte\MySql\mysql-5.7.23-winx64\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
#The function is to skip the login verification#skip-grant-tables 

1. Open the cmd command window as an administrator and switch the directory to the bin directory of the MySQL installation directory:
cd /d D:\workSofte\MySql\mysql-5.7.23-winx64\bin

2. Execute the following statement to install MySQL (after executing the command, it will prompt: Service successfully installed. Indicates successful installation):

mysqld -install

Or (mysqld install MySQL –defaults-file="D:\workSofte\MySql\mysql-5.7.23-winx64\my.ini" // You can use mysqld remove to delete)

3. Execute the following statement to initialize MySQL (after executing the command, a data directory will be generated under the MySQL installation directory and a root user will be created):

mysqld --initialize-insecure --user=mysql

Note: If you do not perform this step, the MySQL service will fail to start when you start it. The service does not report any errors.

4. Execute the following command to start the mysql service:

net start mysql

5. After starting MySQL, the root user's password is empty. Set the password with the following command (when you need to enter the old password, just press Enter because the old password is empty):

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

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.