Do not use the system "mysql" database to install Drupal
Problem/Motivation
When using mysql (which is the default), the Drupal installation seems to happen in the system "mysql" database.
We should install Drupal on another database.
Steps to reproduce
For example: https://git.drupalcode.org/issue/entity_usage-3430263/-/jobs/1872430
SQLSTATE[HY000]: General error: 1465 Triggers can not be created on system tables
Proposed resolution
Change the database to another one.
Start by changing https://git.drupalcode.org/project/gitlab_templates/-/blob/main/includes/include.drupalci.main.yml?ref_type=heads#L26
MYSQL_DATABASE: mysql to something else, say drupal_database, and test.