Installation-free configuration tutorial for mysql 5.7 and installation-free configuration tutorial for mysql

Installation-free configuration tutorial for mysql 5.7 and installation-free configuration tutorial for mysql

It took me two days to figure it out. I hope it will be helpful to new users. If you have any questions, please contact us!

Mysql is divided into the installation version msi, free installation to compress version ZIP, download URL: http://dev.mysql.com/downloads

The installation-free configuration includes the following steps:
1. The first step to Extract files, casually put in a folder, such as: D: \ mysql-5.7.15-winx64

2. Configure the environment variable and append D: \ mysql-5.7.15-winx64 \ bin after the system variable path

3. Copy the my-default.ini, name it my. ini, open my. ini, and add
Basedir = D: \ mysql-5.7.15-winx64
Datadir = D: \ mysql-5.7.15-winx64 \ data
Bind-address = 0.0.0.0
Port = 3306 (note that the previous # is removed when this content is fixed)

4. Run cmd as administrator and enter D: \ mysql-5.7.15-winx64 \ bin (enter D: Press ENTER *** enter cd D: \ mysql-5.7.15-winx64 \ bin press Enter)

5. This step is very important to create a data folder, some previous versions have data folders, but not now, enter after D: \ mysql-5.7.15-winx64 \ bin in cmd
Mysqld -- initialize-insecure -- user = mysql
In this way, the data folder is created,

6. Run mysqld-install to install the Service. If the installation is successful, the following message is displayed: Service successfully installed.

7. start the service and execute net start mysql

*******************/
8. Also enter the D: \ mysql-5.7.15-winx64 \ bin file in cmd, execute mysql-u root-p
Enter password:
Press enter to log on as root.

9. Change the password, enter D: \ mysql-5.7.15-winx64 \ bin, execute mysqladmin-uroot-p password command, prompt to enter the original password,
The original password is blank. Press enter, enter the new password, and then confirm the password to log on.