美文网首页
logstash遇见的坑

logstash遇见的坑

作者: Echoooo_o | 来源:发表于2020-01-17 21:29 被阅读0次

[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;

相关文章

网友评论

      本文标题:logstash遇见的坑

      本文链接:https://www.haomeiwen.com/subject/gyehzctx.html