Node JS HeidiSQL

Aeolus's profile image Aeolus posted 4 years ago in Creating a connection Permalink

First, I'll like to say that I'm enjoying learning SQL on HeidiSQL; it's great, intuitive, and using to use. I'm trying to finish up my lesson on connecting my SQL database to Node JS. I keep getting an error.

All information I have is attached.

Thank you.

3 attachment(s):
  • SQL-connection
  • error
  • HeidiScreen
ansgar's profile image ansgar posted 4 years ago Permalink

In HeidiSQL you are providing a password, which you don't do in your code.

However, the error shows a different cause: HeidiSQL comes with some client plugins, in the "plugin" subfolder. The user (root) on the server is probably configured to use one of these client/authentication plugins, which you don't have in your Node MySQL library.

Please login to leave a reply, or register at first.