MySQL 5.7.31 64-bit free installation version tutorial diagram

1. Download

Download address: https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.19-winx64.zip

2. Configuration File

2.1 Unzip the downloaded compressed package to the folder you want to install (without Chinese), my own file location is F:\Program Files\mysql-5.7.31-winx64 (without Chinese) 2.2 Configure environment variables 2.2.1 My Computer -> Properties -> Advanced -> Environment Variables, create a new MYSQL_HOME, t add the path to the bin folder in the MySQL folder, for example: F:\Program Files\mysql-5.7.31-winx64

2.2.2 Add %MYSQL_HOME%\bin to Path

2.3. Create the my.ini file in the F:\Program Files\mysql-5.7.31-winx64 directory

2.4. Add the following code to the my.ini file (note to change the path name to your own)

[mysqld]
basedir=D:\software\MySQL\mysql-5.7\
datadir=D:\\software\MySQL\mysql-5.7\data\
port=3306

3. Install the database

3.1 To be on the safe side, start CMD in administrator mode, then enter sc delete mysql to delete the mysql service

3.2 Start CMD in administrator mode, switch the path to the bin directory under mysql-5.7.31-winx64, and then enter mysqld –install (install mysql) This step is used to install the mysql service

3.3 After the installation is successful, enter

mysqld --initialize-insecure --user=mysql

Initialize the database

3.4 Start the MySQL service and enter

net start mysql 

3.5 After starting the service, enter

mysql -uroot -p

Enter the MySQL management interface (no need to write the password), and when Enter password: pops up, continue to press the Enter key to log in to MySQL (if you cannot log in after pressing Enter, you need to add skip-grant-tables to the last line of the my.ini file and set it to not check when logging in. After completion, you need to delete the last line) to enter the following interface

4. Change password

4.1 Enter the command use mysql ;

4.2 Enter the command ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密碼' ; (Set the password, note the semicolon at the end)

4.3 Enter the command flush privileges;( refresh privileges)

4.4 Generally, the installation is successful. Enter the command exit ; (exit)

4.5 Finally, test whether you can log in successfully. This is the first time I write a blog. If there is anything wrong, please correct me. Thank you!

This is the end of this article about the tutorial for using MySQL5.7.31 64-bit free installation version. For more relevant content about MySQL5.7.31 64-bit free installation version, please search for previous articles on 123WORDPRESS.COM or continue to browse the related articles below. I hope everyone will support 123WORDPRESS.COM in the future!