MySQL5.7 connection problem with 8.0 (vs2015\2017)

1.

MySQL8.0 root password forgot reset is different from 5.7, most experience posts do not work 8.0

Https://dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html
8.0 How to reset your password

2.

MySQL connection vs2015 times error Tip:

Authentication method ' Caching_sha2_password ' not supported by any of the available plugins

[Turn] Pro test easy to use

The reason for this problem is (MySQL 8.0.4 start default-authentication-plugin parameter is set by default is Caching_sha2_password, I installed the mysql8.0.11, in order to enable the DB2DB connection, the following processing:

(1), change the password encryption method

Alter user ' root ' @ ' localhost ' identified with Mysql_native_password by ' password ';

(2), modify the configuration file default encryption method, modified to Mysql_native_password

Default_authentication_plugin=mysql_native_password

If the configuration file is not in the MySQL root directory, it is possible under the hidden folder C:\ProgramData\MySQL

(3), restart MySQL service

3.

Visual Interface Navicat, workbench error 2059

Reason to solve such as 2

4.

mysql-connector-net-6.10.5 display environment already exists unable to install

Suspected to have failed to install the registry is not clear torture the goblin ah =. =

After installing successfully in mysql-installer-community-5.7.20.0

5.

Navicat importing SQL always fails, too lazy to find the reason

Don't be lazy, the two orders, the data lost scare cry

Common source Commands
Enter the MySQL database console, as
Mysql-u root-p
Mysql>use Database
Then use the source command, followed by the script file (for example, the. SQL used here)
Mysql>source D:/dbname.sql

Wait, it's over.

MySQL5.7 connection problem with 8.0 (vs2015\2017)