Fleet – Error creating DB connection

Problem

You receive the following error

Error creating db connection: this authentication plugin is not supported

when running command:

sudo /usr/bin/fleet prepare db –mysql_address=127.0.0.1:3306 –mysql_database=kolide –mysql_username=root –mysql_password=xxxx –logging_debug

Fix
Verify your version

fleet version –full

fleet – version 1.0.9
branch: heads/1.0.9
revision: c1f4c42
build date: 2018-09-18T18:20:21Z
build user: zwass
go version: go1.10.2

Run the following command to create a new MySQL user with native password encryption (not caching_sha2_password)

Create USER ‘fleetroot’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘xxxx’;
GRANT ALL ON kolide.* TO ‘fleetroot’@’localhost’;

Rerun the command

/usr/bin/fleet prepare db –mysql_address=127.0.0.1:3306 –mysql_database=kolide –mysql_username=fleetroot –mysql_password=xxxxx

Migrations completed.

Tested Platform
Fleet V1.0.9
CentOS 7

Hits: 10

Leave a Reply