Connect to MySQL database with Node.js

Question

I'm experiencing an issue when trying to connect to a MySQL database with Node.JS in my React Native application.

var mysql = require('mysql');

var con = mysql.createConnection({
    host: "localhost",
    user: "root",
    password: "",
    port: 8889,
    database: "blabla"
}); 

con.connect(function(err) {
    if (err) console.log(err);
});

I can access to phpmyadmin without any problem (same user and password) but when I execute the JS file the terminal seems to load but stay stuck like this:

I don't think that there is a link with React but I really have no idea about it.

Thanks in advance for your help

Kodie Grantham · Accepted Answer · 2017-08-10 17:09:01Z

2

According to the mysql docs: https://www.npmjs.com/package/mysql you need to add con.end(); after you are finished with the connection.

answered Aug 10, 2017 at 17:09

Kodie Grantham

2,0372 gold badges23 silver badges28 bronze badges

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

Comments

Koko · Accepted Answer · 2017-08-10 17:05:04Z

0

I just understood that I didn't exit the script, but it's working (sorry).

The line to end the script for Node.js beginners like me:

process.exit()

answered Aug 10, 2017 at 17:05

Koko

1091 silver badge9 bronze badges

1 Comment

robertklep Over a year ago

Until the connection is closed (see Kodie Grantham's answer), Node will not exit the process itself. Once you close the connection, Node will exit too.

Collectives™ on Stack Overflow

Connect to MySQL database with Node.js

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related