Setup ghost.js on Ubuntu 20.04 and MySQL 8.0

After migrating from an Ubuntu 18.04 and MySQL 5.7 - i experienced following error:

ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client

The solution was from following post by altering the password:

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

FLUSH PRIVILEGES;

MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

I can’t make a simple connection to the server for some reason. I install the newest MySQL Community 8.0 database along with Node.JS with default settings. This is my node.js code var mysql =

Stack OverflowPig

General User Setup was not sufficient:

How To Create a New User and Grant Permissions in MySQL | DigitalOcean

MySQL is a powerful database management system used for organizing and retrieving data. This tutorial explains how to to create new MySQL users and how to grant them the appropriate permissions.

DigitalOceanEtel Sverdlov