Error message: Incorrect table name or Identifier name ... is too long

Problem

It is not possible to create one or more tables.

Cause

Usually the prefix in wp-config.php of $table_prefix = 'XXX'; is too long, so MySQL/MariaDB limits are exceeded and tables cannot be created.

Solution

The prefix has to be changed and should not be longer than 3 to 5 characters. To do this, shorten the value of $table_prefix and then rename all tables in the database.