MySQL 5.7 installation-free configuration graphic tutorial

Mysql is a popular and easy-to-use database software. The following is a record of my experience in configuring the mysql free installation version.

1. Software Download

5.7 32-bit https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.19-win32.zip

5.7 64-bit https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.19-winx64.zip

This tutorial uses the 64-bit version, and you can handle it as appropriate according to your computer system and personal preferences.

2. Operation steps

1. Get the zip package after downloading

2. Unzip it to the directory you want to install it to. I unzipped it to D:\Program Files (considering that the file name will be very long after unzipping, I named it that way)

3. Add environment variables

My Computer -> Properties -> Advanced -> Environment Variables

Select PATH and add the bin folder under your mysql installation file after it:
(eg: D:\Program Files\mysql-5.7\bin )

(Be careful not to delete other things)

4. Create a new my.ini file

5. Edit the my.ini file

[mysqld]
basedir=D:\Program Files\mysql-5.7\
datadir=D:\Program Files\mysql-5.7\data\
port=3306
skip-grant-tables
#basedir indicates the mysql installation path #datadir indicates the mysql data file storage path #port indicates the mysql port #skip-grant-tables indicates ignoring the password 

6. Start CMD in administrator mode, switch the path to the bin directory under mysql, and then enter

mysqld –install 

7. Enter net start mysql to start the MySQL service

8. Then enter mysqld --initialize-insecure --user=mysql; to initialize the data file

9. Then restart mysql and use the command mysql –u root –p to enter the mysql management interface (the password can be empty)

10. Change the root password after entering the interface

update mysql.user set authentication_string=password('123456789') where user='root' and Host = 'localhost';

123456789 is my new password. The password here is up to you.

Finally, enter flush privileges to refresh permissions

11. Modify the my.ini file and delete the last sentence skip-grant-tables

12. Restart mysql and it will work normally

Summarize

The above is the graphic tutorial for configuring the MySQL 5.7 free installation 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!