mysql 5.7.11 winx64 quick installation and configuration tutorial_MySQL

This article shares the installation and configuration method of mysql 5.7.11 for your reference. The specific content is as follows

1. General idea of ​​installation:
Download the zip installation package from the official website;
Unzip and copy to C drive;
Configure environment variables;
Modify the configuration file my-default.ini in the mysql root directory;
Initialize mysql, install mysql, start mysql service;
Change root user password;
Installed successfully.

2. Specific step instructions
1. Download the installation package.
2. Copy to C drive:
After unzipping, copy the folder to the C drive: C:Program Filesmysql. It is recommended that the folder name be simple.
3. Configure environment variables:
Computer->right-click->Advanced system settings->Advanced->Environment variables->Modify Path,
Paste the address bar "C:Program Filesmysqlbin;" to the end,
Note: Use English ";" to separate different paths, confirm, and exit.
4. Modify the configuration file my-default.ini in the mysql root directory:
First, create a new data folder in the mysql directory;
Secondly, edit the configuration file my-default.ini:
Remove the #
in front of basedir and datadir What basedir adds is the decompression path of MySQL: C:Program Filesmysql
What datadir adds is the MySQL data folder path: C:Program Filesmysqldata.
Finally, save and close. The picture below is a screenshot of my my-default.ini content:
5. Initialize mysql, install mysql, and start the mysql service [This step is very important]:
My DOS command execution and results are as follows:

C:\Program Files\mysql\bin>mysqld --initialize-insecure --user=mysql
C:\Program Files\mysql\bin>mysqld install mysql --defaults-file="C:\Program File
s\mysql\my-default.ini"
Service successfully installed.
C:\Program Files\mysql\bin>net start mysql<br />

mysql service is starting.
The mysql service has been started successfully.
6. Change root user password:
After installation, the root password is empty by default, and it is recommended to change it.

c:>mysql –u root
mysql>show databases; 
mysql>use mysql;
mysql>UPDATE user SET password=PASSWORD("123456") WHERE user='root';
mysql>FLUSH PRIVILEGES;
mysql>QUIT 

7. Success.
At this point, the installation is successful. It is recommended to use navicat for mysql x64 as the management tool

The above is the entire content of this article. I hope it will be helpful to everyone’s study and I hope you will support me a lot.