【mysql】不允许来自主机的链接错误解决方案
错误信息
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;