Hi Ruprecht, yes, if a provider not changed the default authentication (mysql_nativ_password) there is nothing customers have to do, because the default authentication on mysql 5.7 and 10.5 is the same (SHA-1 based). Mysql changed this starting from version 8, were the default authentication now is the plugin caching_sha2_password. Mariadb not changed the default, but recommends to use a safer authentication method like the ed25519-plugin.
I would like to use it, but then i have the problem that PHP (the Mysql nativ driver) cames with an error like "The server requested authentication method unknown to the client". So i would be glad if this authentication method would be implemented. Regards, Dimi
