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 27, 2021 10:19AM

https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html says the option ought to be in the [mysqld] section of my.cnf.

Quote

Peter - your patience with this is extremely appreciated and will hopefully help others in the future (when resolved!!!)

Unfortunately the MySQL 8.0 default authentication plugin change has caused much time-consuming trouble for many users.



Edited 1 time(s). Last edit at 06/27/2021 10:22AM 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 27, 2021 10:19AM


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.