错误信息

FHost '192.168.1.214' is not allowed to connect to this MySQL server

检查是否存在用户权限

SELECT user, host FROM mysql.user;

创建用户权限

CREATE USER 'root'@'192.168.1.214' IDENTIFIED BY 'yourpassword';

更新用户权限

ALTER USER 'root'@'192.168.1.214' IDENTIFIED BY 'yourpassword';

授予权限 

GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.214' WITH GRANT OPTION;

刷新权限

FLUSH PRIVILEGES;