title: Why can I no longer select data from table "groups" with MySQL 8.0
body: <p>Today I had to rebuild our BugZilla installation. It has been painful, mainly because I unintentionally incurred an upgrade from MySQL 5.7 to MySQL 8.0. Now BugZilla is reporting an SQL syntax error. In an attempt to debug this, I connected directly to the database using the MySQl client and ran the following query:</p>
  <pre><code>SELECT * FROM groups;
  </code></pre>
  <p>This results in the error:</p>
  <pre><code>ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups' at line 1
  </code></pre>
  <p>The same query works for any other table, just not &quot;groups&quot;. I am exhausted and have no energy left to solve this. I am guessing that MySQL 8.0 introduced &quot;GROUPS&quot; as a keyword. I would appreciate some help.</p>