no caching_sha2_password support

[basd82]

Mysql password are deprecated and no longer supported by default on mysql 8.4
Please add functionality to connect with ssl so we kan use caching_sha2_passworderd .

and no enable mysql_native password is not an option becouse its not secure and deprecated

[erikschul]

Just stumbled upon the same issue.

MySQL 8.0+ uses caching_sha2_password by default instead of mysql_native_password

It's disabled by default now, so long term this is going to cause issues if not fixed.

[basd82]

Its a issue already Met vriendelijke groet, Bas van den Dikkenberg

…

________________________________ From: erikschul ***@***.***> Sent: Tuesday, February 25, 2025 4:38:08 PM To: prometheus/mysqld_exporter ***@***.***> Cc: Bas van den Dikkenberg ***@***.***>; Author ***@***.***> Subject: Re: [prometheus/mysqld_exporter] no caching_sha2_password support (Issue #918) Just stumbled upon the same issue. MySQL 8.0+ uses caching_sha2_password by default instead of mysql_native_password It's disabled by default now, so long term this is going to cause issues if not fixed. — Reply to this email directly, view it on GitHub<#918 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AAJJY6K75756ZFG57KNVJU32RSE6BAVCNFSM6AAAAABXNN3BDWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDMOBSGM4DKMBZGA>. You are receiving this because you authored the thread.Message ID: ***@***.***> [erikschul]erikschul left a comment (prometheus/mysqld_exporter#918)<#918 (comment)> Just stumbled upon the same issue. MySQL 8.0+ uses caching_sha2_password by default instead of mysql_native_password It's disabled by default now, so long term this is going to cause issues if not fixed. — Reply to this email directly, view it on GitHub<#918 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AAJJY6K75756ZFG57KNVJU32RSE6BAVCNFSM6AAAAABXNN3BDWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDMOBSGM4DKMBZGA>. You are receiving this because you authored the thread.Message ID: ***@***.***>