Do not use the system "mysql" database to install Drupal
>>> [!note] Migrated issue
<!-- Drupal.org comment -->
<!-- Migrated from issue #3463044. -->
Reported by: [fjgarlin](https://www.drupal.org/user/2495842)
Related to !362 !241
>>>
<h3 id="summary-problem-motivation">Problem/Motivation</h3>
<p>When using mysql (which is the default), the Drupal installation seems to happen in the system "mysql" database.<br>
We should install Drupal on another database.</p>
<h4 id="summary-steps-reproduce">Steps to reproduce</h4>
<p>For example: <a href="https://git.drupalcode.org/issue/entity_usage-3430263/-/jobs/1872430">https://git.drupalcode.org/issue/entity_usage-3430263/-/jobs/1872430</a><br>
<code>SQLSTATE[HY000]: General error: 1465 Triggers can not be created on system tables</code></p>
<h3 id="summary-proposed-resolution">Proposed resolution</h3>
<p>Change the database to another one.</p>
<p>Start by changing <a href="https://git.drupalcode.org/project/gitlab_templates/-/blob/main/includes/include.drupalci.main.yml?ref_type=heads#L26">https://git.drupalcode.org/project/gitlab_templates/-/blob/main/includes/include.drupalci.main.yml?ref_type=heads#L26</a><br>
<code>MYSQL_DATABASE: mysql</code> to something else, say <code>drupal_database</code>, and test.</p>
<h3 id="summary-remaining-tasks">Remaining tasks</h3>
<h3 id="summary-ui-changes">User interface changes</h3>
<h3 id="summary-api-changes">API changes</h3>
<h3 id="summary-data-model-changes">Data model changes</h3>
issue