navcat连接外部mysql出现 Access denied for user ‘root‘@‘localhost‘

步骤：

vi /mydata/mysql/conf/my.cnf
添加  skip-grant-tables 

重启mysql   docker restart mysql

连接mysql  docker exec -it mysql bash

登录mysql  mysql -u root -p 直接回车

修改用户密码为空  update user set authentication_string='' where user='root';

回到my.cnf 删除 skip-grant-tables 

再次登录mysql 

修改密码 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';

修改host update user set host = '%' where user = 'root' and host='localhost';

最后授权 GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';