Answers.Body: <p>It sounds like you have mysql 8. Civi isn't yet fully compatible with mysql 8. So yes for now try mariadb (&lt;= 10.3).</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-06-20T18:56:11.247Z
Answers.Text: Thank you.  That worked.
  At least on my laptop : )
  Kicking out MySQL and slipping in Mariadb wasn't as easy for me as the their website would indicate. Took a bit to get Mariadb to start. 
  Now I have to figure out how to do the security updates.
Answers.UserDisplayName: apple muncy
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-07-02T16:37:14.663Z
Answers.Text: According to the docs the latest CiviCRM does support MySQL 8 now (but it looks like this is fairly recent so this may not be the case with older versions): https://docs.civicrm.org/installation/en/latest/general/requirements/#mysql-8
Answers.UserDisplayName: William Mortada
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-07-02T16:47:59.880Z
Answers.Text: The key phrase there is "through the execution of our test matrix". But test coverage of civi is low percentage-wise so there will still be places where it doesn't work yet. However, yes it does mean that there is intent to support it fully and if bugfixes are submitted they'll get looked at.
Answers.UserDisplayName: Demerit
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-06-19T14:04:24.970Z
Answers.LastActivityDate: 2021-06-19T14:04:24.970Z
Answers.UserDisplayName: Demerit
Answers.Body: <p>If you haven't done so already, I suggest you take a look at the <a href="https://docs.civicrm.org/installation/" rel="nofollow noreferrer">Installation Guide</a> and in particular the <a href="https://docs.civicrm.org/installation/en/latest/general/requirements/" rel="nofollow noreferrer">Requirements</a>.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-07-02T16:33:54.270Z
Answers.LastActivityDate: 2021-07-02T16:33:54.270Z
Answers.UserDisplayName: William Mortada
Body: <p>I'm of the &quot;host or you're toast&quot; philosophy so I'm trying to get a working instance of CiviCRM on either a virtual Ubuntu 20.04 instance on a local qemu/kvm server or personal laptop. Usual LAMP with WordPress working. Web install fails on both with the same error about &quot;grouping&quot;.</p>
  <p>It's a nice refresher course in SQL, etc.</p>
  <p>But what should I try to do next to get a working instance?
  Drop in mariaDB, dump MySQL?</p>
  <p>Rip out apt installed CiviCRM. Download the CiviCRM tar.gz to get the latest version?</p>
  <p>Forget the web install. Use CLI cv method?</p>
  
Tags: <installation><local>
Title: Local install guidance
ThreadText: # Local install guidance
  
  (Asked by: username_0 on 2021-06-19)
  
  I'm of the "host or you're toast" philosophy so I'm trying to get a working instance of CiviCRM on either a virtual Ubuntu 20.04 instance on a local qemu/kvm server or personal laptop. Usual LAMP with WordPress working. Web install fails on both with the same error about "grouping".
  
  It's a nice refresher course in SQL, etc.
  
  But what should I try to do next to get a working instance?
  Drop in mariaDB, dump MySQL?
  
  Rip out apt installed CiviCRM. Download the CiviCRM tar.gz to get the latest version?
  
  Forget the web install. Use CLI cv method?
  
  **Tags:** installation, local
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2021-06-19. Score: 2
  
  It sounds like you have mysql 8. Civi isn't yet fully compatible with mysql 8. So yes for now try mariadb (<= 10.3).
  
  > **Comments:**
  > **username_0**: Thank you.  That worked. At least on my laptop : ) Kicking out MySQL and slipping in Mariadb wasn't as easy for me as the their website would indicate. Took a bit to get Mariadb to start.  Now I have to figure out how to do the security updates.  
  > **username_2**: According to the docs the latest CiviCRM does support MySQL 8 now (but it looks like this is fairly recent so this may not be the case with older versions): https://docs.civicrm.org/installation/en/latest/general/requirements/#mysql-8  
  > **username_1**: The key phrase there is "through the execution of our test matrix". But test coverage of civi is low percentage-wise so there will still be places where it doesn't work yet. However, yes it does mean that there is intent to support it fully and if bugfixes are submitted they'll get looked at.  
  
  ---
  
  ### Answer by username_2 on 2021-07-02. Score: 1
  
  If you haven't done so already, I suggest you take a look at the [Installation Guide](https://docs.civicrm.org/installation/) and in particular the [Requirements](https://docs.civicrm.org/installation/en/latest/general/requirements/).
  
  
  ---
  
  