How to fix an error with recoding tables through sql query in MySQL database?

Question

MySQL

1) It all started with the appearance of the "table encoding" error when testing the system in the Bitrix admin panel.

Already 1942 errors. I looked at the database in phpmyadmin and realized that I would manually change the encoding for each table and field for a week.
2) Found an alternative solution - through sql query. In the database in the sql tab, I entered the query: and clicked "ok".
3) Queries were generated for each table:

4) I copied them back to the sql tab:

5) After that, this error was displayed:

How to fix it and not manually recode the necessary tables and fields?

Answer 1

I don’t know what and how it is in Bitrix, you need to configure the server and client correctly.
Here you can read how to set it up better.