Error during login to new MySQL 8 server

TSchm posted 8 months ago in General

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?

ozyrys posted 8 months ago

You must change your user:

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

TSchm posted 8 months ago

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.

ozyrys posted 8 months ago

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

KIA-Nick posted 5 months ago

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.

kalvaro posted 4 months ago

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.)

kalvaro posted 4 months ago

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

fosowp posted 3 months ago

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.