Hey getting a access denied to MySQL when trying to setup Kolide. Doing the migration step. Mysql is on the same box

Have you created a new mysql user just for kolide and granting it permissions to the db? I had this issue when I was initially using the root mysql user.

I am using root. I will try that

fleet-user@kolide-fleet:~$ fleet prepare db
Error creating db connection: Error 1698: Access denied for user 'root'@'localhost'
mysql> create user '$username'@'localhost' IDENTIFIED BY '$password';
Query OK, 0 rows affected (0.00 sec)
mysql> grant all privileges on * . * to '$username'@'localhost';
Query OK, 0 rows affected (0.00 sec)
mysql> exit;
fleet-user@kolide-fleet:~$ fleet prepare db
Migrations completed.

That was my flow, if it's an issue other than that, I'm not sure.

mysql grants are very precise. Hostname vs sockets are a common issue. Eg: you grant local access via socket, and then the client connects via network. Or vice versa.