MySQL Forums
Forum List  »  Newbie

Re: mysqldump new problem
Posted by: Scott Jalbert
Date: November 29, 2021 10:41AM

Peter Brawley Wrote:
-------------------------------------------------------
> Oh, I missed them. If you are getting an access
> denied error, something in authentiucation has
> changed. Have you recently upgraded to MySQL 8? If
> so, the authentication default method has changed
> to caching_sha2_password, see
> https://dev.mysql.com/doc/refman/8.0/en/caching-sha2-pluggable-authentication.html,
> it breaks most previous authentication
> configurations.. If that's so, other logins eg the
> mysql client should also be affected.

I don't see any errors there, the sql file is created fine but it just doesn't have the contents in it. Previous dump files were 750+ megabytes and took a couple minutes to perform.

Application is zabbix and it should be using the same account as I'm doing the dump under. The application has no problems and is working fine.

I do regularly update/upgrade the server, but I think we started out with v8 on this 20.04 box. Now it is showing Server version: 8.0.27-0ubuntu0.20.04.1 (Ubuntu)

Options: ReplyQuote


Subject
Written By
Posted
November 29, 2021 09:37AM
November 29, 2021 10:00AM
November 29, 2021 10:10AM
November 29, 2021 10:24AM
November 29, 2021 10:32AM
Re: mysqldump new problem
November 29, 2021 10:41AM
November 29, 2021 12:29PM
November 29, 2021 12:45PM
November 29, 2021 01:24PM
November 29, 2021 02:07PM


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.