@Syed_Muhammad_Dawoud Note: this is going to break people who are running with the MySQL fix to get around the Open edX regression where it broke emoji support: Upgrading MySQL charset to utf8mb4 - #4 by dave
I happen to be trying to upgrade a system to Palm with that plugin enabled, and I started running into the same error.
Specifically, the plugin provided by tutor plugins install https://gist.githubusercontent.com/Abdess/3ed9ed1d42821d00a5cf2481870df26f/raw/tutor-mysql8utf8mb4.yml
is set to override to image: docker.io/mysql:latest.
I’m going to try and set it to image: docker.io/mysql:8.1.0 (the way it was before that PR) so I can work around this. I had already upgraded my server and it got 8.4.0 and then couldn’t downgrade back.
But if that doesn’t work with 8.1, and I really need 8.4 on Palm, then how can I adjust that plugin parameters to make it work? I tried adding --mysql-native-password=ON but then I started getting ERROR 2007 (HY000): Protocol mismatch; server version = 11, client version = 10 instead, which I couldn’t figure out a way around…