I know this is a well trodden path, but my review of SO posts around this yielded no results. So this is a fresh installation of MySQL and Visual Studio 2019 on my dev machine - like both literally vanilla tonight. I used the Development installation for MySQL:
So I can connect to a test database just fine with Server Explorer. I can also Add Connection fine (that is it sees the remote database), but when I come to click next on Choose your data connection, I get this error:
I come across this problem every time I try to set up MySql and VS together. On this occation, I'm working with the latest MySQL version and thus have gone for the latest MySql binaries. As I say, I've reviewed all of the historic SO posts, but cant apply them to this. Does anyone have any ideas? (I had to downgrade to VS2019 because there's no MySql for VS 2022).