[ERROR][logstash.inputs.jdbc ] Unable to connect to database. Tried 1 times {:error_message=>"Java::JavaSql::SQLException: null, message from server: "Host '192.168.0.104' is not allowed to connect to this MySQL server""}
进入MySQL
mysql -u root -p
使用MySQL库
use mysql;
更新一条允许所有主机访问数据库
UPDATE user SETHost= '%' WHEREUser= 'root' LIMIT 1;
强制刷新权限
flush privileges;
查看一下是否写入
SELECTHost,UserFROM user;
