V1.21 to v1.22 upgrade - Expect database to use collation: utf8mb4_0900_as_cs

Upgraded from 1.21 to 1.22 using MySQL 8 in docker compose environment.
There is no CHARSET defined in app.ini.

I’m seeing…

I would like to know how to run gitea doctor convert - when I attach to gitea container it says I can’t run gitea as root.

Can someone let me know how to run this gitea command or modify MySQL database? Does it apply to some or all tables?

The FAQs and searches dont seem to have quite enough detail… and not sure how to run gitea command line in a docker compose based deployment.