Splunk Search

Splunk db connect: "host is not allowed to connect to MySQL"

aquillius
New Member

I'm trying to connect to the database of another server for me to build dashboards but i can't connect. anyone here knows how to fix the error?

here's the error:
ERROR java.sql.SQLException: null, message from server: "Host '192.168.1.140' is not allowed to connect to this MySQL server"

0 Karma

richgalloway
SplunkTrust
SplunkTrust

Have you told MySQL to allow connections from the Splunk server? Something like "GRANT ALL PRIVILEGES ON *.* TO 'user'@'192.168.1.140'" should do it.

---
If this reply helps you, Karma would be appreciated.
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...