Mysql 5.7.11 installation and configuration tutorial, 5.7.11 installation and configuration tutorial

Mysql 5.7.11 installation and configuration tutorial, 5.7.11 installation and configuration tutorial

Step 6: Install mysql5.7.11 easily
1. Download the installation package. Mysql-5.7.11 version:
2. Copy to any disk:
For example, after decompression, copy the folder to drive C: \ Program Files \ mysql. It is recommended that the folder name be in English.
3. Configure environment variables:
Computer-> right-click-> advanced system settings-> advanced-> environment variable-> modify Path, paste the address bar "C: \ Program Files \ mysql \ bin;" to the end, note: different paths are separated by English ";", OK, 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.
Add skip-grant-tables to log on without a password for the first time
Add default_password_lifetime = 0 password permanently valid
Add max_connect_errors = 99999 Max Link error count
Finally, save and close.
......
Basedir = C: \ Program Files \ mysql
Datadir = C: \ Program Files \ mysql \ data

Port = 3306

Skip-grant-tables

Default_password_lifetime = 0

Max_connect_errorrs = 99999
......

5. initialize mysql, install mysql, and start the mysql service. [This step is very important ]:

C: \ Program Files \ mysql \ bin> mysqld -- initialize-insecure -- user = mysql
C: \ 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 root
Mysql> show databases;
Mysql> use mysql;
Mysql> UPDATE user SET authentication_string = password ('20140901') WHERE user = 'root ';
Mysql> flush privileges;
Mysql> QUIT

The above is how to install and configure mysql 5.7.12winx64. I hope it will be helpful for your learning.