Is this on a linux localhost? Have you checked the link above for possible commands to fix this? Everything I could find points at a environment problem. Some sort of mix up with MySQL versions. There isn't anything I can do about that; you'll need to fix your environment. If you're using a web host try contacting them to see if they can re-install MySQL and PHP. I've tested your exact versions in a clean docker image and it works fine.
You can also try unpublishing all 3rd party extensions and retry to see if issue persists.
I guess as a workaround you can create the field then change its JSON type in _comprofiler to TEXT type, but if you re-save the field it will force the field type back to JSON. This would just be a bandaid for a bigger issue with your environment.