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"
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.
"GRANT ALL PRIVILEGES ON *.* TO 'user'@'192.168.1.140'"