balderdashy / balderdashy/sails

Can't connect to MAMP MySQL

Open
#6,546 2 comments 0 reactions 0 assignees View on GitHub
mysql orm try this out please v1.x
Dominant language
JavaScript
Stars
22.8k
Forks
1.9k
PR merge metrics
No merged PRs in 30d

Description

**Node version**: 8.15.0
**Sails version** : 1.2.2
**DB adapter & version** : sails-mysql@1.0.1


I want to connect to a mysql instance ( throught MAMP ).

Here's my datastores configuration :

```
adapter: 'sails-mysql',
host:'localhost',
user: 'root',
password: 'root',
database: 'aops',
port: 8889,
socketPath: '/Applications/MAMP/tmp/mysql/mysql.sock'
```

I get the ECONNREFUSED when i try to lift.
It seems the mamp socket is ignored.
I haven't found anything except [this old stack overflow](https://stackoverflow.com/questions/33344847/how-to-use-a-unix-socket-mamp-instead-of-a-port-for-sails-js-db-connection) on a old sails version, which does not work on sails 1.1.0

Is connecting to a MAMP socket still possible ?

EDIT : updated versions

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the ECONNREFUSED failure during `sails lift` with the reported Sails, Node, sails-mysql, MAMP, port, and socketPath configuration. Trace how the datastore configuration reaches the MySQL adapter, then verify whether the MAMP socket is honored; done means the documented configuration connects successfully without the refusal.

Written by the indexing model from the issue text.

Assessment

Tech stack
javascript, mysql, node.js
Domain
backend, databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.