MySQL Forums
Forum List  »  Newbie

Re: MYSQLDUMP on remote Ubuntu from Windows 10 now fails with Got error: 2059: "Authentication plugin 'caching_sha2_password' cannot be loaded:
Posted by: Peter Brawley
Date: June 26, 2021 01:01PM

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.

Options: ReplyQuote


Subject
Written By
Posted
Re: MYSQLDUMP on remote Ubuntu from Windows 10 now fails with Got error: 2059: "Authentication plugin 'caching_sha2_password' cannot be loaded:
June 26, 2021 01:01PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.