Title
#kolide
r

Robert Nixon

11/22/2019, 3:32 PM
Hey getting a access denied to MySQL when trying to setup Kolide. Doing the migration step. Mysql is on the same box
Matt K

Matt K

11/22/2019, 3:34 PM
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.
r

Robert Nixon

11/22/2019, 3:49 PM
I am using root. I will try that
4:13 PM
Created a user called fleet and gave it rights to everything and that failed too. I can login with the MySQL cli.
Matt K

Matt K

11/22/2019, 4:20 PM
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.
s

seph

11/22/2019, 5:27 PM
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.