title: Laravel 5.5 with MySQL 8.0.11: 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'
body: <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>