I am having mysql data base in another system and trying to connect to that system, but I got error and telling to check grafana logs. After checking I have got this error:-
level=error msg=“query error” err=“Error 1130: Host ‘FINJD-13’ is not allowed to connect to this MySQL server”
What permissions does FINJD-13 have on mysql?
Sorry it seems like I have entered wrong port before, but now I have entered a port
and it’s mentioned in logs like this -
connectex: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond."
Look at the logs on mysql.
Will check and let you know. Thanks
I am using MYSQL Workbench 8.0. I have went to path -
C:/Program Files/Mysql Workbench 8.0 / data /
Inside data I didn’t find any logs file. which file shall I check for logs ?
Workbench is a tool for querying mysql data so the mysql logs wont be located there.
Since this is not a grafana issue, finding mysql logs, I would encourage you to research that yourself.