Database error 1140 in Dashboard and 1055 in Statistics

I can change the database, as long as the changes do not conflict with other programs, mainly Moodle, that wants the following:
[client]
default-character-set = utf8mb4

[mysqld]
innodb_file_format = Barracuda
innodb_file_per_table = 1
innodb_large_prefix = 1

character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
skip-character-set-client-handshake

[mysql]
default-character-set = utf8mb4

How should I change it?