New libmysq with auth plugin caching_sha2_password ?

TomasB posted 3 months ago in General

In newer version of MySQL (>=8.0.3) is used new authentication plugin. The libmysql.dll supplied with HeidiSQL doesn't support it and when I just copy new version 8.0.4 to Heidi's dir I'm getting error "Cannot find a usable libmysql". Can you change code to support new libmysql ?

ebyrob posted 3 months ago

Hi TomasB,

I just had a similar issue which I reported as HeidiSQL issue #163 on GitHub.

However, I got a different error message: Authentication plugin 'caching_sha2_password' cannot be loaded: The specified module could not be found.

So I can't be certain these are related. Just in case they are related, I thought I would cross-post here.

Thanks, ebyrob

cacofony posted 1 month ago

From some testing I have done, there does not seem to be a version of libmysql.dll for 32bit

edenilson_s posted 6 days ago

If your MySQL installation is >=8.0.3, i recommend locating your MySQL installation and copying the libmysql.dll file to your current HeidiSQL installation.

Example:

copy C:\Program Files\MySQL\MySQL Router 8.0\bin\libmysql.dll to C:\Program Files\HeidiSQL\libmysql.dll

You will find that the version of the libmysql.dll file is larger than the one distributed in the current installation of your HeidiSQL.

hug

steinhaug posted 4 days ago

I had same problems after installing new server with latest mysql and such.

Open up and modify my.ini file located most likely at C:\ProgramData\MySQL\MySQL Server 8.0 Look for "[mysqld]" and edit the line with "default_authentication_plugin" value to:

[mysqld]
default_authentication_plugin=mysql_native_password

Restart the MySQL Service

From the command line you can access MySQL and create the new user:

CREATE USER 'the_username'@'localhost' IDENTIFIED BY 'the_password';
GRANT ALL PRIVILEGES ON . TO 'the_username'@'localhost';

Now you can connect again, using the new user.

Please login to leave a reply, or register at first.