• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

Question mysql_native_password to caching_sha2_password for database user

Nicola

Basic Pleskian
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?

Code:
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?

Immagine 2024-07-31 135949.png

thanks a lot
 
I correct what I wrote, new users created are activated correctly. However, the problem remains for plesk users
 
Back
Top