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: William Damage
Date: June 29, 2021 05:19PM

This issue is resolved now, and sincere thanks to Peter for his help.
However, going back to basics the real issue was just using mysqldump from scripts on mysql 5.7 which stopped when upgrading to mysql 8.0. All the work in this thread to fix it was aimed at reverting the functionality, which increasingly just didn't sit right. Ultimately all the remote servers were going to be on 8.0, and the change was brought in to make it more secure.

I'll not dwell on the full script, but it boils down to the old line

mysqldump --single-transaction --quick --lock-tables=false --max_allowed_packet=1024M $remote_auth -h $host_source $db > dump.sql

being changed to

ssh root@%host_source% "mysqldump --defaults-extra-file=/usr/local/utils/mysql/options.txt %db% | zip -9" > %db%.zip

This works for both versions of remote servers because mysqldump is now being run on them, not locally on Win 10 as before, and the ssh call makes it secure.
So all the work done on the mysql 8.0 server was reverted and the scripts adapted to handle this new method.

Thanks again

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 29, 2021 05:19PM


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.