Hey getting a access denied to MySQL when trying t...
# kolider
Robert Nixon
11/22/2019, 3:32 PMHey getting a access denied to MySQL when trying to setup Kolide. Doing the migration step. Mysql is on the same box
m
Matt K
11/22/2019, 3:34 PMHave 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 PMI am using root. I will try that
Robert Nixon
11/22/2019, 4:13 PMCreated a user called fleet and gave it rights to everything and that failed too. I can login with the MySQL cli.
m
Matt K
11/22/2019, 4:20 PM Copy code
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.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.
2 Views