>>> [!note] Migrated issue <!-- Drupal.org comment --> <!-- Migrated from issue #3555065. --> Reported by: [thomas.fleming](https://www.drupal.org/user/826568) Related to !10 >>> <h3 id="summary-problem-motivation">Problem/Motivation</h3> <p>Drupal\dbal\ConnectionFactory does not include <a href="https://git.drupalcode.org/project/drupal/-/blob/9.2.x/sites/default/default.settings.php#L191">init_commands</a>. In some hosting environments, such as Acquia, default variables cannot be overridden globally and need to be set per session via init_commands, as described <a href="https://docs.acquia.com/acquia-cloud-platform/mysql-transactions">here</a> for changing the transaction_isolation variable from REPEATABLE-READ to READ-COMMITTED.</p> <h4 id="summary-steps-reproduce">Steps to reproduce</h4> <p>Set init_commands in settings.php to change a variable, such as transaction_isolation, and run <code>drush ev 'print_r(\Drupal::service("dbal_connection")-&gt;executeQuery("SHOW VARIABLES;")-&gt;fetchAll());' | grep -C2 _isolation</code> to check the value. Currently, only the default database variable will be returned.</p> <h3 id="summary-proposed-resolution">Proposed resolution</h3> <p>Include init_commands after getting the connection:</p> <div class="codeblock"> <pre><span style="color: #000000"><span style="color: #0000BB">&lt;?php<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style="color: #007700">if (isset(</span><span style="color: #0000BB">$info</span><span style="color: #007700">[</span><span style="color: #DD0000">'init_commands'</span><span style="color: #007700">])) {<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; foreach (</span><span style="color: #0000BB">$info</span><span style="color: #007700">[</span><span style="color: #DD0000">'init_commands'</span><span style="color: #007700">] as </span><span style="color: #0000BB">$sql</span><span style="color: #007700">) {<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><span style="color: #0000BB">$this</span><span style="color: #007700">-&gt;</span><span style="color: #0000BB">cache</span><span style="color: #007700">[</span><span style="color: #0000BB">$target</span><span style="color: #007700">]-&gt;</span><span style="color: #0000BB">executeStatement</span><span style="color: #007700">(</span><span style="color: #0000BB">$sql</span><span style="color: #007700">);<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<br></span><span style="color: #0000BB">?&gt;</span></span></pre></div> <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>