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 ?
New libmysq with auth plugin caching_sha2_password ?
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.
From some testing I have done, there does not seem to be a version of libmysql.dll for 32bit
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.
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.
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:
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.