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;