Problem
Description
The issue that I am currently facing can be described with an error telling me that access has been denied to one of my mySQL Databases that I have set up with InfinityFree. I have tried many solutions which can be found on the forum but unfortunately none of the solutions seemed to fulfill my specific issue.
Code
// Set Up Our MySQL Connections
const connection = mySQL.createConnection({
host: 'oceanicairlines.rf.gd',
user: 'epiz_26138384',
password: '***************',
database: 'epiz_26138384_oceanicairlines'
});
connection.query('SELECT * FROM users WHERE 1', (err,rows,fields) => {
if (err) throw err;
console.log(rows);
});
Error
Error: connect ECONNREFUSED 185.27.134.133:3306
at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1141:16)
--------------------
at Protocol._enqueue (C:\Users\*****\Documents\Oceanic Airlines Bot\node_modules\mysql\lib\protocol\Protocol.js:144:48)
at Protocol.handshake (C:\Users\*****\Documents\Oceanic Airlines Bot\node_modules\mysql\lib\protocol\Protocol.js:51:23)
at Connection.connect (C:\Users\*****\Documents\Oceanic Airlines Bot\node_modules\mysql\lib\Connection.js:116:18)
at Connection._implyConnect (C:\Users\*****\Documents\Oceanic Airlines Bot\node_modules\mysql\lib\Connection.js:454:10)
at Connection.query (C:\Users\*****\Documents\Oceanic Airlines Bot\node_modules\mysql\lib\Connection.js:196:8)
at Object.<anonymous> (C:\Users\*****\Documents\Oceanic Airlines Bot\index.js:21:12)
at Module._compile (internal/modules/cjs/loader.js:1138:30)
at Object.Module._extensions..js (internal/modules/cjs/loader.js:1158:10)
at Module.load (internal/modules/cjs/loader.js:986:32)
at Function.Module._load (internal/modules/cjs/loader.js:879:14) {
errno: 'ECONNREFUSED',
code: 'ECONNREFUSED',
syscall: 'connect',
address: '185.27.134.133',
port: 3306,
fatal: true
}
Solutions
My Attempts
Attempt #1
With my first attempt at fixing the problem, I tried to change the user and password to the username and password of my InfinityFree account. This idea was sparked by this post which describes how someone was using the incorrect username and password.
Attempt #2
I also tried to change the host to sql300.epizy.com, which is what it says in the client area (I think that’s what it is called?) for MySQL Hostname, thinking they would correspond to each other.
Results
Unfortunately, with my luck in code debugging, none of them worked. That is why I am calling out to the forums, as I see in other posts that most of the time, the issues are solved.
Additional Information
Additional Information
My Coding Interface
I am using Visual Studio Code to make a Discord bot for my fictional airline. The current dependency that I am using for this is ‘mysql’, running version 2.18.1. The whole thing is written in JavaScript. If it helps, here is a list of all my dependencies, in JSON format:
"dependencies": {
"body-parser": "^1.19.0",
"discord.js": "^12.2.0",
"express": "^4.17.1",
"morgan": "^1.10.0",
"mysql": "^2.18.1"
}
New User
I am a new user and had just joined today. I apologize if I am using an incorrect format for these forums, I have been to many other types of Discourse Forums and usually when I post on them, I use this type of format. Please let me know if I need to change something; help would be greatly appreciated.
Since I am a new user, I am used to remotemysql.com to access my mySQL Databases, however I am switching because this has more data that I can put in the databases. When I was using that site, everything worked fine, so I am not sure if I am transferring a habit which is only for it over to here, or if I am just missing something.
Thank you for taking time to read my post, and I hope to hear back.