Navicat Error 1251 connection not successful MySQL

There is a 1251 error when using Navicat to connect to the database, the workaround.

1. First open the Mysql.exe, then enter the password (Mysql.exe can search in the installation location)

2. Enter alter USER ' root ' @ ' localhost ' identified with mysql_native_password by ' MySQL password '; Enter don't miss a semicolon. mysql password is when you install MySQL Set the password

3. Enter flush privileges; Don't miss the back semicolon.

4. Start Navicat again to connect to the database successfully.

Navicat Error 1251 connection not successful MySQL