We are successfully using mysqldiff as part of our build process to validate our migration scripts with MySQL 5.7. This has been a perfect solution for us for years. We are looking to upgrade to MySQL 8.0.13, but are running into the following error:
ERROR: Authentication plugin 'caching_sha2_password' is not supported
We have configured the database user with _mysql_nativepassword but this apparently is not sufficient. Presumably, we need to have mysqldiff use the version 8 driver. It is unclear (to us) if this is something we can easily do, or if the fix is more complicated.
We are looking for a fix or workaround for both Windows 10 and Amazon Linux.
We are successfully using mysqldiff as part of our build process to validate our migration scripts with MySQL 5.7. This has been a perfect solution for us for years. We are looking to upgrade to MySQL 8.0.13, but are running into the following error:
We have configured the database user with _mysql_nativepassword but this apparently is not sufficient. Presumably, we need to have mysqldiff use the version 8 driver. It is unclear (to us) if this is something we can easily do, or if the fix is more complicated.
We are looking for a fix or workaround for both Windows 10 and Amazon Linux.