Question mysql_native_password to caching_sha2_password for database user

[Nicola]

Server operating system version

Almalinux 8

Plesk version and microupdate number

18.0.62 #2

Hello,
in the database logs I find this warning. In fact when I create users from the plesk interface I can't choose the password saving method and the passwords are stored with "mysql_native_password". I would like the "caching_sha2_password" plugin to be used by default but I can't do this from plesk. Is there a solution other than making the change directly in the database?

2024-07-01T09:09:36.008844Z 35365 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'

also i see plesk database users are using this plugin too, how can i update password saving method without breaking plesk?



thanks a lot

 

[Nicola]

I correct what I wrote, new users created are activated correctly. However, the problem remains for plesk users

 

[Aleksei Fedorov]

Hello, if you use MySQL 8 you can change the default plugin but there are no guarantees