Configuration text tutorial for MySQL5.7 without installation, text for mysql5.7

Configuration text tutorial for MySQL5.7 without installation, text for mysql5.7

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

I. 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, which can be handled by zuser based on his computer system and personal preferences.

Ii. Procedure

1. Download and get the zip package

 

2. decompress the package to the directory you want to install. I decompress the package to D: \ Program Files (I named the Files since the Files are very long after decompression)

 

3. Add Environment Variables

My computer-> properties-> advanced-> Environment Variables

Select PATH and add it to the "bin" folder under your mysql Installation File.
(Such as: D: \ Program Files \ mysql-5.7 \ bin)

 

(Do not delete other items)

4. Create the 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 = 3306skip-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 in mysql, and enter

Mysql-install

 

7. Enternet start mysql Start mysql Service

 

8. Enter mysqld --initialize-insecure --user=mysql; Initialize data files

 

9. Start mysql again and run the command mysql –u root –pGo to the mysql Management page (the password can be blank)

 

10. Enter the interface and change the root password.

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

123456789 is my new password, which is determined by you

Last Inputflush privileges Refresh permission

 

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

 

12. Restart mysql to work properly.

Summary

The above is an installation-free configuration text tutorial for MySQL5.7. I hope it will help you. If you have any questions, please leave a message and I will reply to you in a timely manner. Thank you very much for your support for the help House website!