使用Navicat连接服务器的mysql，以及连接时的报错问题

1. 首先在服务器上登陆进去mysql，然后输入：

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '你的密码' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)
 
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

如果报错：

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'identified by '你的密码' with grant option' at line 1

这么整：

mysql> CREATE USER 'root'@'%' IDENTIFIED BY '你的密码';
Query OK, 0 rows affected (0.48 sec)

mysql> grant all privileges on *.* to 'root'@'%';
Query OK, 0 rows affected (0.48 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

2. 在本机上打开Navicat，新建MySQL连接

如果报错：

解决方法：

mysql> use mysql;
Database changed   

mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '你的密码';
Query OK, 0 rows affected (0.00sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec) 

然后再试着连接就OK了