Re: MYSQLDUMP on remote Ubuntu from Windows 10 now fails with Got error: 2059: "Authentication plugin 'caching_sha2_password' cannot be loaded:

[Peter Brawley]

Quote

I will if you think there's something I'm missing here but remember how this looks from an earlier message?

mysql> select host, user, plugin from mysql.user where user like 'root%';
+-----------+----------+-----------------------+
| host | user | plugin |
+-----------+----------+-----------------------+
| % | root | mysql_native_password |
| localhost | root | mysql_native_password |
| localhost | roottest | mysql_native_password |
+-----------+----------+-----------------------+
3 rows in set (0.01 sec)

Right you are, again my mistake.

In the Ubuntu system, execute ...

select @@default_authentication_plugin;

Look in all .cnf files for a line beginning with default_authentication_plugin. If there is one change it to ...

default_authentication_plugin=mysql_native_password

... and if there's not one, add it as above; reboot MySQL, again check the plugin var.

Then when logged into the Ubuntu system rather than your Windows system, run mysqldump to ensure the caching_sha2_password error is gone.



Edited 1 time(s). Last edit at 06/26/2021 01:02PM by Peter Brawley.