https://github.com/osquery/osquery logo
#kolide
Title
d

demonbhao

08/13/2020, 2:22 AM
Hi I would like to ask you how to solve the problem that I set according to the document but could not connect to mysql.
s

seph

08/13/2020, 2:26 AM
Mysql permission grants to localhost are unusual. There is a separate grant things connecting over the local socket, than things connecting over tcp. And
localhost
, despite being a hostname, generally refers to the socket.
So a common gotcha is to grant permissions to connections over the socket, which then fail.
For your command line case, try connecting to
127.0.0.1
and seeing if it works.
d

demonbhao

08/13/2020, 2:30 AM
I think I have connected 127.0.0.1
s

seph

08/13/2020, 2:31 AM
That’s fleet. Does it work from
mysql
You example is using a socket.
d

demonbhao

08/13/2020, 2:50 AM
Sorry, I still don't understand how to solve this problem
s

seph

08/13/2020, 2:53 AM
Your fleet screenshot connects to 127.0.0.1. Your second screenshot, using the mysql command line tool connects via socket. Try connecting with
-h 127.0.0.1
d

demonbhao

08/13/2020, 3:08 AM
I solved the above problem, but how can I access the Fleet background of the test environment locally
Why didn't I respond after I pressed Enter?
Thanks for your help, I have already deployed Fleet
2 Views