Re: No Node.js Access To MySQL Community Database . . .
First things first:
allow Applications to connect to the Database as root
create an account for your Application to [exclusively] use, grant it appropriate permissions and have your Application connect as that account.
keep the biggest and best Tools in the Toolbox for your own
use (to clean up the mess made by everyone/everything
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.