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