Question : 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
Answered by : naughty-narwhal-6cbwdygi5kww
$ mysql -u root -p
Enter password: (enter your root password)
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_new_password';
mysql> FLUSH PRIVILEGES;
mysql> quitSource : https://stackoverflow.com/questions/50093144/mysql-8-0-client-does-not-support-authentication-protocol-requested-by-server | Last Update : Tue, 02 Jun 20
Question : Client does not support authentication protocol requested by server; consider upgrading MySQL client
Answered by : joshua-reid
# Run this line to unistall mysql and install mysql2
npm un mysql && npm i mysql2
# then switch the name of your import in your node file
#const mysql = require("mysql2");
#mysql2 uses the updated form of authentication
# To learn more read this stackoverflow answer: https://stackoverflow.com/a/56509065/13776398Source : | Last Update : Thu, 21 Oct 21
Question : Client does not support authentication protocol requested by server; consider upgrading MySQL client
Answered by : maira-marraffini
$ mysql -u root -p
Enter password: (enter your password)
mysql> ALTER USER 'root' IDENTIFIED WITH mysql_native_password BY 'PASSWORD';
mysql> FLUSH PRIVILEGES;
mysql> quitSource : | Last Update : Fri, 16 Apr 21
Question : mysql Client does not support authentication protocol requested by server; consider upgrading MySQL client
Answered by : henry-obiaraije
/* First run this */
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
/* Where root as your user localhost as your URL and password as your password */
/* Then flush all prvilates */
flush privileges;Source : | Last Update : Wed, 13 Apr 22
Question : Client does not support authentication protocol requested by server; consider upgrading MySQL client
Answered by : abdullah-itangishaka
// Run this line to unistall mysql and install mysql2
npm uninstall mysql && npm install mysql2
// Switch the name of your import in your node file
import mysql2 from 'mysql2'
// mysql2 uses the updated form of authenticationSource : | Last Update : Mon, 26 Sep 22