使用第三方工具链接时报ip错误的时候大概率是mysql没开启远程访问
开启方式
GRANT ALL PRIVILEGES ON *.* TO 'root'@'本地电脑ip' IDENTIFIED BY '数据库密码' WITH GRANT OPTION
mysql> GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
mysql>FLUSH PRIVILEGES;
设置仅此ip才可连接
重启mysql即可