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 25, 2021 12:46PM

Apologies, I managed to confuse myself ... to change mysql.user.plug=caching_sha2_password settings on your remote server, you will need to bring down that MySQL server, start it with the --skip-grant-tables option, login from there without credentials, change those plugin values to mysql_native_password, flush privileges, then restart that server.

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 25, 2021 12:46PM


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.