tsh db connect fails with mysql client version 9

[greedy52]

Expected behavior:
tsh db connect should succeed with mysql

Current behavior:

$ mysql --user teleport-admin --port 8888 --host localhost --protocol TCP
ERROR 2059 (HY000): Authentication plugin 'mysql_native_password' cannot be loaded: dlopen(/opt/homebrew/Cellar/mysql-client/9.0.1/lib/plugin/mysql_native_password.so, 0x0002): tried: '/opt/homebrew/Cellar/mysql-client/9.0.1/lib/plugin/mysql_native_password.so' (no such file), '/System/Volumes/Preboot/Cryptexes/OS/opt/homebrew/Cellar/mysql-client/9.0.1/lib/plugin/mysql_native_password.so' (no such file), '/opt/homebrew/Cellar/mysql-client/9.0.1/lib/plugin/mysql_native_password.so' (no such file)

Bug details:

• Teleport version: v16

This is an upstream issue tracked here: Homebrew/homebrew-core#180498

Downgrade 8.4 works fine. (brew install [email protected])

However we should investigate MySQL version 9 in general and move away from native password auth:

teleport/lib/srv/db/mysql/proxy.go

Lines 174 to 180 in d489930

	func (p *Proxy) makeServer(clientConn net.Conn, serverVersion string) *server.Conn {
	return server.MakeConn(
	clientConn,
	server.NewServer(
	serverVersion,
	mysql.DEFAULT_COLLATION_ID,
	mysql.AUTH_NATIVE_PASSWORD,

[SMillerDev]

It is an upstream issue, but it seems nobody actually reported it upstream to MySQL yet.

[greedy52]

Thanks @SMillerDev! I see this fixed now on brew side.

Teleport should still investigate our use of mysql.AUTH_NATIVE_PASSWORD in our source code