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’m short for "configuration file.” What am I?

May 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with a Special ...

New Articles from Academic Learning Partners, Help Expand Lantern’s Use Case Library, ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Your Guide to SPL2 at .conf24!

So, you’re headed to .conf24? You’re in for a good time. Las Vegas weather is just *chef’s kiss* beautiful in ...