Error during login to new MySQL 8 server

I just installed the new version of MySQL 8. When I try to open the connection I receive the error message: "Authentication plugin 'caching_sha2_password' cannot be loaded".

Is this related to the new MySQL version or to my installation?

You must change your user:

ALTER USER 'user'@'host' IDENTIFIED WITH mysql_native_password BY 'YourPassword';

This ist not what I want to do, at least not as a permanent solution. As far as I understand the 'caching_sha2_password' is the new standard for login, so it would be nice if HeidiSQL could handle those connections.

Yes, true. For moment when HeidiSQL get new libmysqlclient with support new authentication.

I keep getting the same issue, whats the easiest way to fix it as i dont have a clue what im doing when it comes to coding. Thanks, Nick.

I've been able to log in from HeidiSQL by replacing this file:

%ProgramFiles%\HeidiSQL\libmysql.dll

... with this:

%ProgramFiles%\MySQL\MySQL Server 8.0\lib\libmysql.dll

However, the User Manager does not seem to support caching_sha2_password authentication strings. It doesn't recognise existing passwords and passwords set here do not work when connecting from e.g. PHP. (I've had to set passwords from other programs such as MySQL Workbench.)

Related issue ticket: #163 Failure connecting Heidi 9.5 to MySQL 8.0 due to missing plugin: caching_sha2_password

I've been able to log in from HeidiSQL by replacing this file:

%ProgramFiles%\HeidiSQL\libmysql.dll

... with this:

%ProgramFiles%\MySQL\MySQL Server 8.0\lib\libmysql.dll

However, the User Manager does not seem to support caching_sha2_password authentication strings. It doesn't recognise existing passwords and passwords set here do not work when connecting from e.g. PHP. (I've had to set passwords from other programs such as MySQL Workbench.)

Thank you for a concise easy solution.