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)