logstash遇见的坑

[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 SET Host = '%' WHERE User = 'root' LIMIT 1;
强制刷新权限
flush privileges;
查看一下是否写入
SELECT Host,User FROM user;