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?
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.)
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.
Please login to leave a reply, or register at first.