For detailed information about this and other Node.js database bindings visit the [Node.js db-mysql homepage] homepage.
Before proceeding with installation, you need to have the libmysql development libraries and include files. Access to the mysql_config binary is mandatory, and its path has to be specified prior to installation (if its not within the system's path). For example, if the path to your mysql_config is /usr/local/bin/mysql_config make sure to do the following (Ubuntu users need to install the libmysqlclient-dev package):
$ export MYSQL_CONFIG=/usr/local/bin/mysql_config
Once you are sure that either mysql_config is part of the path or that you specified the MYSQL_CONFIG environment var, install with npm:
$ npm install db-mysql
var mysql = require('db-mysql');
new mysql.Database({
hostname: 'localhost',
user: 'root',
password: 'password',
database: 'node'
}).on('ready', function() {
this.query().select('*').from('users').execute(function(error, rows) {
if (error) {
console.log('ERROR: ' + error);
return;
}
console.log(rows.length + ' ROWS');
});
}).connect();
This module is released under the [MIT License] license.