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

osquery

Okay our old server gave us so much trouble we're scrapping it and starting over fresh. I'm having trouble finding how to configure MySQL so Fleet is happy. What encoding and collation is correct?

Also which permissions does the Fleet MySQL user need?

We're not on AWS so I can use the supplied Terraform, and it assumes whatever AWS has set up as defaults.

I tried to let Fleet create the DB but I got an "unknown database" error

I found `utf8mb4_unicode_ci` in the codebase, will try that.

Here is some documentation to our <https://fleetdm.com/docs/deploy/reference-architectures#mysql|Reference architectures>, which contains additional links to configure MySQL.

Yes, I looked through all that, I couldn't find MySQL configuration info. Just how to configure Fleet for MySQL.

<@UN9SVU8JW> Fleet does enforce collation and charset (UTF-8). As for permissions, the user will need full control of the database. Hope this helps!

Thanks. We've always had UTF-8, but we've run into multiple update issues when the collation wasn't exactly what Fleet was expecting. Hopefully the collation I mentioned above will continue to work.