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

osquery

Hmm looks like I need to GRANT myself additional permissions... sorry for the noise

Connect to MySQL
```$ mysql -u root -p```
When prompted enter in the temporary password from `/var/log/mysqld.log`
Change root password, in this case we will use `toor?Fl33t` as default password validation requires a more complex password.
For MySQL 5.7.6 and newer, use the following command:
```mysql&gt; ALTER USER "root"@"localhost" IDENTIFIED BY "toor?Fl33t";```
For MySQL 5.7.5 and older, use:
```mysql&gt; SET PASSWORD FOR "root"@"localhost" = PASSWORD("toor?Fl33t");```
Now issue the command
```mysql&gt; flush privileges;```


Though i think your problem is your not use your root user

and your normal user as you said is not granted the rights, which you probably need to do UNDER the root user

** Also im still a newbie at this stuff - so I am answering what i feel is right, even though only setting this up 2 weeks ago