(一)刚安装完mysql-5.7.26,使用navicat连接mysql时出现如下错误:
1045 -Access denied for user 'root'@'222.26.7.73'(using password:YES)
(二)解决办法: 登录mysql数据库进行远程登录授权.
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
(三)测试使用navicat远程连接mysql: