Osquery uses basic SQL commands to leverage a relational data-model to describe a device.

osquery

2.jpg

1.jpg

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.

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.

3.jpg

That’s fleet. Does it work from `mysql` You example is using a socket.

Sorry, I still don't understand how to solve this problem

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`

4.jpg

I solved the above problem, but how can I access the Fleet background of the test environment locally

5.jpg

Why didn't I respond after I pressed Enter?

Thanks for your help, I have already deployed Fleet