I installed mysql-8.0.11-winx64 and SQLyog-13.0.1-0.x64Community in my Windows-10 laptop. When trying to connect SQLyog with MySQL database using root user not connecting. Showing this error:
I could resolve this issue by creating another user through the following query:
create user '[USERNAME]'@'%' identified with mysql_native_password by '[PASSWORD]';
I could understand Oracle has made default authentication type caching_sha2_password
in MySQL-8. I found article here:
In MySQL 5.7, the default authentication plugin is mysql_native_password. As of MySQL 8.0, the default authentication plugin is changed to caching_sha2_password.
Please find the complete article here: https://dev.mysql.com/doc/refman/5.7/en/caching-sha2-pluggable-authentication.html
Another way to resolve this issue, we can alter the user by changing authentication type from default caching_sha2_password
to mysql_native_password
. This is the similar way to do:
Authentication plugin 'caching_sha2_password' cannot be loaded