Laravel 5.5 with MySQL 8.0.11: 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER' : <p>I've just installed MySQL <code>8.0.11</code>, transfered my app's database into it and changed the laravel database settings to use the new one. Now everytime I try to login I get the following error:</p>

<pre><code>ERROR 1231 (42000):
Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'
</code></pre>

<p>I tried to set <code>NO_AUTO_CREATE_USER</code> manually:</p>

<pre><code>set global sql_mode="..., NO_AUTO_CREATE_USER, ...";
</code></pre>

<p>But I get the same error. How could I solve the problem and run laravel <code>5.5</code> with MySQL <code>8.0.11</code>?</p>
