Nodejs mysql tutorial in xampp

Nodejs mysql tutorial in xampp

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