Navicat premium cannot connect to MySQL

Open up the MySQL command line client.
Type in the following lines perfect, if you mess up, you have to start all over by restarting the command line client.

Mysql> use MySQL
Mysql> Select User, host, password from user;
# Now you shoshould see that u have 3 entries
+ ----------------------------- +
| User | host | password |
+ ----------------------------- +
| Root | localhost |
| Root | 127.0.0.1 |
| Localhost |
+ ----------------------------- +

Mysql> Delete from user where host = "localhost" and user = "";
Mysql> Update user SET Password = PASSWORD ("Root") Where user =" root ";
Mysql> flush tables;
Mysql> flush privileges;
Mysql> quit

Now the MySQL table shocould be updated and everything fixed.