Skip to content

Instantly share code, notes, and snippets.

@intelguasoft
Created July 7, 2020 06:23
Show Gist options
  • Save intelguasoft/1c98de90ef99e557f2da2d807d3cefe9 to your computer and use it in GitHub Desktop.
Save intelguasoft/1c98de90ef99e557f2da2d807d3cefe9 to your computer and use it in GitHub Desktop.
Clavos con la autenticación hacia mysql 8 desde otros clientes.

Execute the following query in MYSQL Workbench

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'

Where root as your user localhost as your URL and password as your password

Then run this query to refresh privileges:

flush privileges;

Try connecting using node after you do so.

If that doesn't work, try it without @'localhost' part.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment