How to Change Authentication Method in MySQL? [Ubuntu-18.04]
This issue exists because of the Authentication Method in MySQL. By default during the installation, the authentication method for our user is set to the auth_socket method/plugin. You can observe the configuration by checking your mysql instance via sudo login.