Nodejs-mysql operation example

// Demo-mysql.jsvar for MySQL = require ('mysql'); var client = new MySQL. client (); client. host = 'localhost'; client. user = 'root'; client. password = '000000'; client. query ('show databases', function (ERR, rows, fields) {If (ERR) {// error happend console. log (ERR);} else {console. log (rows);} client. end ();});

Run:

# Node demo-mysql.js

If the MySQL module is not installed, use NPM to install it:

# NPM install MySQL or # NPM install-G MySQL

The "-G" parameter is installed in the system's default Module Directory. Otherwise, it is installed in the current directory.

If the MySQL module has been installed and cannot be found, it is a module path problem. You can make a soft link in the working directory or add it to the environment variable.

# Ln-S $ prefix/bin/node_modules