mysql caching_sha2_password

22/09/2022

le bug :

[Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'

npm mysql ne gere pas ce plugin : caching_sha2_password
donc on installe npm mysql2

liste les users

SELECT HOST, USER, Plugin FROM mysql.user;

change le plugin de connection d'un user

ALTER USER 'root'@'%'
IDENTIFIED WITH 'caching_sha2_password'
    BY 'ccccccccc';

ALTER USER 'root'@'localhost'
IDENTIFIED WITH 'caching_sha2_password'
    BY 'cccccccccc';

flush privileges;

Raccourcis