Download some pits for installing MySQL

In the process of MySQL download installation will have some pits, in addition navicat connection MySQL database there is a certain pit, summarized as follows:

1. A DLL file is missing from the computer

This problem to solve, download a file on the right,: https://www.microsoft.com/en-US/download/details.aspx?id=48145

2, after the installation is complete, start MySQL error

This is due to a lack of an initialization step, such as:

Then it started successfully, as follows:

By the way, if you want to save trouble, do not want to CD to the MySQL installation directory to hit the command, you can directly put the MySQL installation directory into the environment variables.

3, navicat connection MySQL Error

When the user is created and the cracked version of navicat8.0 is installed, this error occurs:

MySQL Client does not the authentication protocol requested by server; Consider upgrading MySQL

At first glance, as if the Navicat version is low, and then re-download the installation, found or error, the root cause of this error is that after the 4.1.x version, using the password hashing algorithm based authentication protocol, the algorithm is incompatible with the password hashing algorithm used by the old client.

On this error, the answer on the Internet 99% can not solve the error problem, now the correct answer affixed:

A. Log in with the root account first

B. Change your password

Finally you can use Navicat to log in normally, but it is recommended to create a new user, do not use the root user directly. The new user created will also need to change the password as the root account.

Download some pits for installing MySQL