Search
 
SCRIPT & CODE EXAMPLE
 

SQL

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

Execute the following query in MYSQL Workbench

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 run this query to refresh privileges:

flush privileges;

Try connecting using node after you do so.

If that doesn't work, try it without @'localhost' part.
Comment

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

npm install mysql2
Comment

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

import mysql from "mysql2";
Comment

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

const mysql = require("mysql2")
Comment
PREVIOUS NEXT
Code Example
Sql :: stop mysql ubuntu 
Sql :: insert column with default value in sql 
Sql :: su: Authentication failure mysql 
Sql :: wordpress change http to https phpmyadmin 
Sql :: postgresql datetrunc too slow 
Sql :: append column sql 
Sql :: postgres read table structure 
Sql :: tsql create unique index composite 
Sql :: sql drop primary key 
Sql :: install mysqldump ubuntu 
Sql :: postgresql alter column nullable 
Sql :: mysql count newlines in field 
Sql :: mysql get last id 
Sql :: How to fetch data in between startfromdate to starenddate in sql 
Sql :: mysql dump mysql db cli 
Sql :: mysql calculate age 
Sql :: funzioni plsql 
Sql :: create a table with an id in mysql 
Sql :: installing mysql on fedora 
Sql :: nvl postgres 
Sql :: create procedure with encryption 
Sql :: sql server alter table add column datetime default current_timestamp 
Sql :: sql output inserted id 
Sql :: mqtt Error: Address not available 
Sql :: date_format for time sql 
Sql :: alter table drop column 
Sql :: creating a view sql 
Sql :: drop all foreign key constraints mysql 
Sql :: find most frequent value in sql column 
Sql :: sql myisam vs innodb 
ADD CONTENT
Topic
Content
Source link
Name
8+4 =