Nodejs uses the mysql tutorial in xampp, nodejsxampp

Nodejs uses the mysql tutorial in xampp, nodejsxampp

The following describes how to connect to the mysql database of the local machine through node. js:

Var mysql = require ('mysql'); var connection = mysql. createConnection ({host: 'localhost', user: 'xxxx', // replace xxxx with your mysql login Username password: 'xxxx ', // replace xxxx with your mysql logon Password database: 'xxxx', // replace xxxx with the database name socketPath: '/Applications/XAMPP/xamppfiles/var/mysql. sock ', port: 3306}); connection. connect (function (err) {if (err) {console. error ('error connecting: '+ err. stack); return;} console. log ('connectedas id' + connection. threadId );});

The key here is to configure socketPath. Otherwise, the following error will be reported:

Error connecting: Error: connect ECONNREFUSED