MySQL Forums
Forum List  »  Connector/Node.js

Re: No Node.js Access To MySQL Community Database . . .
Posted by: Phillip Ward
Date: November 22, 2021 08:06AM


user: "root",
password: Publically-Published-Password-Pipped

First things first:

Do not allow Applications to connect to the Database as root.
Always create an account for your Application to [exclusively] use, grant it appropriate permissions and have your Application connect as that account.

Always keep the biggest and best Tools in the Toolbox for your own use (to clean up the mess made by everyone/everything else!)

Do not put passwords into your Application source code.
Always read them, at run-time, from an external, secure source.


The app does NOT execute any of the console logs within the MySQL query statement so we don't even know if any connection has been made - I suspect not.

Well, if it's not connecting to the database, then the database can't be doing anything wrong, can it?

That's the first thing you need to work out.
Is it connecting or not and, if not, why not?

I would blindly guess that, if this is a new development, that MySQL's default, super-secure protection of the root account's password is getting in the way. Use a different account, with a "weaker" encryption scheme and you may get further.

Regards, Phill W.

Options: ReplyQuote

Written By
Re: No Node.js Access To MySQL Community Database . . .
November 22, 2021 08:06AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.