/SQL/'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',

'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',

$ 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> quit

Source: stackoverflow.com

Client does not support authentication protocol requested by server; consider upgrading MySQL client

# 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/13776398

MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password ...

Source: stackoverflow.com

Similar codes

0 vote121 views1 answer
Sql contains numeric characters
SQL
1 vote120 views1 answer
Postgres get month name from date
SQL
0 vote136 views1 answer
Mysql coonect sample code
SQL
4 votes125 views3 answers
Postgres set default value
SQL
0 vote144 views3 answers
Constraint sql
SQL
13 votes134 views1 answer
Sql join 3 tables on id
SQL
0 vote118 views1 answer
Oracle search columns in schema
SQL
0 vote137 views1 answer
Exception message: The connection name 'SqlServices' was not found in the applications configuration or the connection string is empty.
SQL
18 votes116 views4 answers
Foreign key mySql
SQL
10 votes110 views3 answers
Join multiple tables sql
SQL