search

scotch-io / scotch-box

Scotch Box is a preconfigured Vagrant Box with a full array of LAMP Stack features to get you up and running with Vagrant in no time.
http://box.scotch.io
2.7k stars 548 forks source link

MySQL access denied from node on localhost, but works from CLI mysql #381

Open Tmp2k opened 6 years ago

Tmp2k commented 6 years ago

Since the latest version of Scotch Box my gulp scripts have stopped working...

var execsql = require('execsql');

var connsettings = {
    host: 'localhost'
    user: 'root',
    password: 'root'
};

var sql = 'some SQL';
execsql.config(connsettings).exec(sql);

This throws an access denied error when ran from the VM. However, "mysql -u root -p" on the command line of the VM works just fine.

The gulp script works fine in v3.0 but does not work in v3.5.