mysql

npm install mysql

Um MySQL mit NodeJS zu nutzen kann man das NPM Packet mysql nutzen.

var MySQLClient = require('mysql').Client;
var mysqlDB = new MySQLClient({user:'user',password:'pass', database:'mysqlnodejs'});

mysqlDB.connect();
mysqlDB.query('SET NAMES "UTF8";');

mysqlDB.query('CREATE TABLE nodetest (id int not null primary key auto_increment, name varchar(255)) engine=innodb default charset=utf8;');

mysqlDB.query('INSERT INTO nodetest (name) VALUES ("Müller");');

mysqlDB.query('SELECT * FROM nodetest;', function(err, rows) {
    if (err) throw err;
    console.log(rows);
    mysqlDB.end();
});