Answers.Body: <p>You need to put those in your mysql configuration file (e.g. sometimes located at /etc/my.ini, depends on your host) as described at <a href="https://docs.civicrm.org/installation/en/latest/general/requirements/#mysql-configuration" rel="nofollow noreferrer">https://docs.civicrm.org/installation/en/latest/general/requirements/#mysql-configuration</a></p>
  <pre><code>[mysqld]
  innodb_large_prefix=true
  innodb_file_format=barracuda
  innodb_file_per_table=true
  </code></pre>
  <p>If you don't have access to that you'll need to ask your hosting company.</p>
  <p>At the time of writing (civi v5.30), all this does is make it possible to use utf8mb4, but civi will still install as utf8. After install, you can manually convert by choosing the menu option Support - Developer - Api explorer v3, and choosing <code>Entity: System</code> and <code>Action: utf8conversion</code> and then clicking the Execute button.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-10-14T13:36:53.867Z
Answers.LastActivityDate: 2020-10-14T13:36:53.867Z
Answers.UserDisplayName: Demerit
Body: <p>I am about to run the CiviCRM installer, but I get the following warning:</p>
  <p>CiviCRM MySQL utf8mb4 Support: It is recommended, though not yet required, to configure your MySQL server for utf8mb4 support. You will need the following MySQL server configuration: innodb_large_prefix=true innodb_file_format=barracuda innodb_file_per_table=true</p>
  <p>However, my database configurations are already as follows:
  <a href="https://i.sstatic.net/s7u6E.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/s7u6E.png" alt="enter image description here" /></a></p>
  <p>So what exactly is &quot;MySQL utf8mb4 Support&quot; and what are the steps to configure it properly? (e.g. what do I do with this exactly? &quot;innodb_large_prefix=true innodb_file_format=barracuda innodb_file_per_table=true&quot;)</p>
  
Tags: <database><installation><configuration>
Title: What does it mean to "configure your MySQL server for utf8mb4 support" when my database charset and collation are already utf8mb4?
ThreadText: # What does it mean to "configure your MySQL server for utf8mb4 support" when my database charset and collation are already utf8mb4?
  
  (Asked by: username_0 on 2020-10-14)
  
  I am about to run the CiviCRM installer, but I get the following warning:
  
  CiviCRM MySQL utf8mb4 Support: It is recommended, though not yet required, to configure your MySQL server for utf8mb4 support. You will need the following MySQL server configuration: innodb\_large\_prefix=true innodb\_file\_format=barracuda innodb\_file\_per\_table=true
  
  However, my database configurations are already as follows:
  [![enter image description here](https://i.sstatic.net/s7u6E.png)](https://i.sstatic.net/s7u6E.png)
  
  So what exactly is "MySQL utf8mb4 Support" and what are the steps to configure it properly? (e.g. what do I do with this exactly? "innodb\_large\_prefix=true innodb\_file\_format=barracuda innodb\_file\_per\_table=true")
  
  **Tags:** database, installation, configuration
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2020-10-14. Score: 2
  
  You need to put those in your mysql configuration file (e.g. sometimes located at /etc/my.ini, depends on your host) as described at <https://docs.civicrm.org/installation/en/latest/general/requirements/#mysql-configuration>
  
  ```
  [mysqld]
  innodb_large_prefix=true
  innodb_file_format=barracuda
  innodb_file_per_table=true
  
  ```
  
  If you don't have access to that you'll need to ask your hosting company.
  
  At the time of writing (civi v5.30), all this does is make it possible to use utf8mb4, but civi will still install as utf8. After install, you can manually convert by choosing the menu option Support - Developer - Api explorer v3, and choosing `Entity: System` and `Action: utf8conversion` and then clicking the Execute button.
  
  
  ---
  
  