Mysql 5.7.11 winx64 quick installation and configuration tutorial, 5.7.11winx64

Mysql 5.7.11 winx64 quick installation and configuration tutorial, 5.7.11winx64

This article shares with you how to install and configure mysql 5.7.11 for your reference. The specific content is as follows:

I. general idea of installation:
Download the zip installation package from the official website;
Decompress the package to drive C;
Configure environment variables;
Modify the configuration file my-default.ini under the mysql root directory;
Initialize mysql, install mysql, and start the mysql service;
Modify the root user password;
The installation is successful.

Ii. Detailed steps
1. Download the installation package.
2. Copy to drive C:
Decompress the package and copy the folder to drive C: \ Program Files \ mysql. It is recommended that the folder name be simpler.
3. Configure environment variables:
Computer-> right-click-> advanced system settings-> advanced-> environment variable-> modify Path,
Paste "C: \ Program Files \ mysql \ bin;" in the address bar to the end,
Note:Different paths are separated by ";" in English. Confirm and exit.
4. modify the configuration file my-default.ini under the mysql root directory:
First, create a new data folder in the mysql directory;
Second, edit the profile my-default.ini:
Remove the one before basedir and datadir #
Basedir adds the MySQL decompression path: C: \ Program Files \ mysql
Datadir adds the data folder path of MySQL: C: \ Program Files \ mysql \ data.
Finally, save and close. Is my my-default.ini content:
5. initialize mysql, install mysql, and start the mysql service. [This step is important ]:
My doscommand runs and the result is as follows:

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

Mysql service is starting.
The mysql service has been started successfully.
6. Modify the root user password:
After installation, the root password is empty by default. We recommend that you modify it.

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

7. Successful.
Now, the installation is successful. We recommend that you use navicat for mysql x64

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.