How to query data from MySQL through Node

Question

I'm new to Node and learning how to query data from MySQL. I get the following error:

err { [Error: ER_BAD_DB_ERROR: Unknown database '201803028'] code: 'ER_BAD_DB_ERROR', errno: 1049, sqlMessage: 'Unknown database \'201803028\'', sqlState: '42000', fatal: true }

here is my code

const mysql = require('mysql');

var db = mysql.createConnection({ host:'localhost', user:'root', password:'123456', database:'201803028'});

db.query('SELECT * FROM user-table;',(err,data)=>{ if(err){ console.log('err',err); }else{ console.log('success',data); } })

Could anyone tell me what's the matter with my coding?

Thank you very much!

The database 201803028 does not exist. You should create it before you connect to it. — Csaba
– Csaba, Commented Mar 28, 2018 at 8:14

code · Accepted Answer · 2021-12-02 15:42:13Z

0

Try this

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

connection.connect();
/* Uncomment the below query to test your connction
connection.query('SELECT 1 + 1 AS solution', function (error, results, fields) {
  if (error) throw error;
  console.log('The solution is: ', results[0].solution);
});*/

edited Dec 2, 2021 at 15:42

code

6,3994 gold badges22 silver badges47 bronze badges

answered Nov 7, 2018 at 17:15

Kiran Bhattarai

1751 silver badge13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

J Jones Over a year ago

Can you provide some explanation in addition to the code example?

Collectives™ on Stack Overflow

How to query data from MySQL through Node

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related