How to tell node.js that mysql is not running on default port?
17,623
Solution 1
When you are initializing the mysql client, along with username and password, you can pass a different value for port.
const client = mysql.createClient({
user: '??',
password: '??',
port: 8889
});
Solution 2
For those initializing the mysql connection object using mysql.createPool({...})
, it's the same solution as the accepted answer. For Reference
const connection = mysql.createPool({
host: ...,
port: 8889,
user: ...,
password: ...,
});
Author by
ario
Updated on June 15, 2022Comments
-
ario almost 2 years
I'm having a problem similar to this person's: connect ECONNREFUSED - node js , sql
I'm trying to connect app.js to an existing database running as part of MAMP. MAMP runs mysql on port 8889; how do I tell node.js which port to find mysql on?