Why does my connection.query with mysql in node not work?

user_5724758 0
Viewed 669

Goal: Do a simple query to the database.

Expected results: "please print something!" and the results from the query are printed on the terminal.

Actual results: Nothing is printed on the terminal.

Errors: No error message.

Here is the db.js file:

var mysql = require('mysql');
    
var connection = mysql.createConnection({
    host: 'localhost',
    user: 'root',
    password: 'root',
    database: 'todoDB'
});

connection.connect();

connection.query('SELECT * FROM categories', function (err, res, fields) {
    console.log("please print something!")
    if (err) throw err;
    console.log(res);
});

connection.end();

I execute this file using:

node db.js

On the mysql cli, I am able to do this query without any problem with the database name, credentials, and query given above.

I know that connection.connect() works since when I'm inputting the code below, the terminal prints "Database is connected!" I think the problem occurs at connection.query, but I am not sure why.

connection.connect(function(err){
    if(!err){
        console.log("Database is connected");
    } else {
        console.log("Error while connecting with database");
        console.log(err);
    }
});

I've looked through all the related questions on stackoverflow and tried them, but none of the solutions seems to resolve the problem that I have.

npm node.js mysql javascript
1 Answers

So it looks like mySQL V8 uses caching_sha2_password as the new authentication standard, which the nodeJS plugin does not support. Connect to your db and try creating a new user that uses the native password auth type.

CREATE USER 'foo'@'localhost' IDENTIFIED WITH mysql_native_password BY 'bar';
user_71382840
Related