This tutorial discusses why and How to change Authentication method for MySQL root user to Caching SHA-2 Pluggable Authentication or Native Pluggable
This tutorial discusses why and How to change Authentication method for MySQL root user to Caching SHA-2 Pluggable Authentication or Native Pluggable Authentication method in Ubuntu.
Even if you have configured a password for the MySQL root user, you cannot use a password to log in with the database server. Because, in Ubuntu systems running MySQL 5.7 and later versions, the MySQL root user is configured by default to authenticate using the auth socket plugin rather than the password. As a result, you cannot access the MySQL server using the root user and password.

















