Re: No Node.js Access To MySQL Community Database . . .
Quote
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/every
thing else!)
Do not put passwords into your Application source code.
Always read them, at run-time, from an external, secure source.
Quote
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.