顯示錯誤1130 - Host '106.228.110.117' is not allowed to connect to this MySQL server

解決方案

進入服務器的mysql命令行

mysql -u root -p

查看數據庫

SHOW DATABASES;

選擇mysql數據庫

USE mysql;

查看里面的表

SHOW TABLES;

查詢user表格的權限限制

SELECT Host, User FROM user;

將權限修改為

UPDATE user SET Host = '%' WHERE User = 'root';

立即刷新

FLUSH PRIVILEGES;