Hi, unfortunately the mysql probe was not updated for a long time and it does not support mysql version 8.Are there any news when a new mysql probe will be published to support mysql version 8?Authentication mode has changed so existing mysql probe is not able to login.
Error message in Connection profile of mysql probe: Client does not support authentication protocol requested by server; consider upgrading MYSQL Clientthank you very much
You can change the authentication plugin used on a per-user basis by running this MySQL command:
ALTER USER 'wp_cli_test'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password1';
Hi Gene,thank you very much for your information and your link with a possible temporary solution. I will ask my mysql colleague if option 1 is really an option for us.Nevertheless is it hard that the support told me that I should raise an idea, where I will receive 2 likes or maybe 3 and no one from Broadcom will recognize it, that we need a new working mysql probe version.The last mysql version 1.51. is from November 2016! It's a long time ago.I must tell my customer that he must wait maybe until 2021/2022 because there is nobody from the support who could tell the engineers that a probe is not working anymore or maybe is someone updating the probe?As you can imagine and I hope you understand that is not the szenario I want to face, if probes don't support newer product versions.Thank you for your support!
Hi @Ashish Aggarwal,I did not doubt that. The problem is that the MySQL Probe v1.51 or v1.54 does not support the new secure authentication method (caching_sha2_password_authentication) of MySQL.Of course I can monitor MySQL 8 but when the admin insists on the secure authentication (not to use the workaround), then unfortunately I cannot monitor these database servers.
The KB article refers to an ETA in the second half of the year. I was hoping to hear a more specific date.