Ufdjrw

I am the person who abides by rules, but breaks the rules. Who am I?

ESPP--any reason not to go all in?

Is it possible to clone a polymorphic object without manually adding overridden clone method into each derived class in C++?

Why does this boat have a landing pad? (SpaceX's GO Searcher) Any plans for propulsive capsule landings?

Should we avoid writing fiction about historical events without extensive research?

What would be the most expensive material to an intergalactic society?

What do you call someone who likes to pick fights?

Is there stress on two letters on the word стоят

Movie: boy escapes the real world and goes to a fantasy world with big furry trolls

Why do phishing e-mails use faked e-mail addresses instead of the real one?

How to install round brake pads

How do I raise a figure (placed with wrapfig) to be flush with the top of a paragraph?

Either of .... (Plural/Singular)

Is "cogitate" used appropriately in "I cogitate that success relies on hard work"?

(Codewars) Linked Lists-Sorted Insert

What does the Digital Threat scope actually do?

What is better: yes / no radio, or simple checkbox?

Idiom for feeling after taking risk and someone else being rewarded

Locked Away- What am I?

Strange opamp's output impedance in spice

When an outsider describes family relationships, which point of view are they using?

Would those living in a "perfect society" not understand satire

If nine coins are tossed, what is the probability that the number of heads is even?

How exactly does an Ethernet collision happen in the cable, since nodes use different circuits for Tx and Rx?

Error: 1252. Client does not support authentication protocol requested by server; consider upgrading MySQL client

1

const mysql = require('mysql2');

const pool = mysql.createPool(
 host: 'localhost',
 user: 'root',
 database: 'node_complete',
 password: 'ankur_54'
);

pool.execute('SELECT * FROM products')
.then(result => 
 console.log(result);
)
.catch(err => 
 console.log(err);
);

This was my code to obtain data from a MySQL table. But it failed to do so, and instead returned this error. I tried using:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'ankur_54';
FLUSH PRIVILEGES;

but unfortunately, that didn't work too. Can anyone help me with this?

mysql node.js

share|improve this question

asked Mar 6 at 13:30

Ankur MazumderAnkur Mazumder

62

New contributor

Ankur Mazumder is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  What's the version of mysql2 package?
  
  – barbsan
  Mar 6 at 13:40
  

  
  
  
  

add a comment | 

1

const mysql = require('mysql2');

const pool = mysql.createPool(
 host: 'localhost',
 user: 'root',
 database: 'node_complete',
 password: 'ankur_54'
);

pool.execute('SELECT * FROM products')
.then(result => 
 console.log(result);
)
.catch(err => 
 console.log(err);
);

This was my code to obtain data from a MySQL table. But it failed to do so, and instead returned this error. I tried using:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'ankur_54';
FLUSH PRIVILEGES;

but unfortunately, that didn't work too. Can anyone help me with this?

mysql node.js

share|improve this question

asked Mar 6 at 13:30

Ankur MazumderAnkur Mazumder

62

New contributor

Ankur Mazumder is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  What's the version of mysql2 package?
  
  – barbsan
  Mar 6 at 13:40
  

  
  
  
  

add a comment | 

const mysql = require('mysql2');

const pool = mysql.createPool(
 host: 'localhost',
 user: 'root',
 database: 'node_complete',
 password: 'ankur_54'
);

pool.execute('SELECT * FROM products')
.then(result => 
 console.log(result);
)
.catch(err => 
 console.log(err);
);

This was my code to obtain data from a MySQL table. But it failed to do so, and instead returned this error. I tried using:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'ankur_54';
FLUSH PRIVILEGES;

but unfortunately, that didn't work too. Can anyone help me with this?

mysql node.js

share|improve this question

asked Mar 6 at 13:30

Ankur MazumderAnkur Mazumder

62

New contributor

Ankur Mazumder is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

const mysql = require('mysql2');

const pool = mysql.createPool(
 host: 'localhost',
 user: 'root',
 database: 'node_complete',
 password: 'ankur_54'
);

pool.execute('SELECT * FROM products')
.then(result => 
 console.log(result);
)
.catch(err => 
 console.log(err);
);

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'ankur_54';
FLUSH PRIVILEGES;

share|improve this question

asked Mar 6 at 13:30

Ankur MazumderAnkur Mazumder

62

New contributor

Ankur Mazumder is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

asked Mar 6 at 13:30

Ankur MazumderAnkur Mazumder

62

New contributor

Ankur Mazumder is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked Mar 6 at 13:30

Ankur MazumderAnkur Mazumder

62

New contributor

Ankur Mazumder is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked Mar 6 at 13:30

Ankur MazumderAnkur Mazumder

62