If you installed MySQL 8.0 and imported OTS schema.sql
with default settings, you database uses encoding not supported by MariaDB.
If you dump database using:
mysqldump dbname > dump.sql
and try to import it into MariaDB using:
mysql dbname < dump.sql
It will show error. To fix this, run these 2 commands:
sed -i 's/utf8mb4_0900_ai_ci/utf8_general_ci/g' dump.sql
sed -i 's/CHARSET=utf8mb4/CHARSET=utf8/g' dump.sql