1. 进入mysql,给root用户开启远程访问
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
Query OK, 0 rows affected, 1 warning (0.01 sec)
2. 刷新权限
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
3. 在navacat中重新连接