title: Wordpress / MySQL - How to fix 'Invalid default value for 'user_registered''
body: <p>I am using Wordpress 5.5 with MySQL 8. I have everything set up, and went to change the structure of the the wp_users table, but can't modify the table because of the error Invalid default value for 'user_registered'</p>
  <p>This is the current column definition as created by Wordpress:</p>
  <pre><code>user_registered datetime default '0000-00-00 00:00:00' not null,
  </code></pre>
  <p>Changing the default value to '0' gives the same error message.</p>
  <p>How can a table exist and work but have an invalid default value? And what is a default value I can enter that will not cause issues with Wordpress?</p>
  <p>I am using DigitalOcean shared MySQL server, so I can't change the server mode to allow zero datetime values.</p>
  <p>I have seen a few answers on this, but they all related to MySQL 5.5 and prior, or don't address how to make Wordpress work with this issue, or require changing the MySQL configuration which is not possible here.</p>
  <p>MySQL version: 8.0.19</p>
  <p>InnoDB version: 8.0.19</p>
  <p>Wordpress version: 5.5.1</p>