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: 458