Horje
Client does not support authentication protocol requested by server; consider upgrading MySQL client Code Example
'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
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 ...
Client does not support authentication protocol requested by server; consider upgrading MySQL client
$ mysql -u root -p
Enter password: (enter your password)

mysql> ALTER USER 'root' IDENTIFIED WITH mysql_native_password BY 'PASSWORD';
mysql> FLUSH PRIVILEGES;
mysql> quit




Shell

Related
install pyspark Code Example install pyspark Code Example
can't kill docker container Code Example can't kill docker container Code Example
push/upload git repo to github Code Example push/upload git repo to github Code Example
git not asking for password Code Example git not asking for password Code Example
delete local git repository command line creates by react Code Example delete local git repository command line creates by react Code Example

Type:
Code Example
Category:
Coding
Sub Category:
Code Example
Uploaded by:
Admin
Views:
11