原因:MySql服务,root用户不允许远程链接;
解决方案:修改MySql——》root 用户——》允许其远程链接;
解决步骤:
MySQL 5.7 Commond Line Client
mysql>
-u root -p
use mysql;
//修改host
update user set host='%' where user='root';
//刷新权限
flush privileges;
//查看验证
select host, user from user;
修改后,重新查询结果:
+-----------+---------------+
| host | user |
+-----------+---------------+
| % | root |
| localhost | mysql.session |
| localhost | mysql.sys |
+-----------+---------------+
3 rows in set (0.00 sec)