How to resolve mysql_full_unicode_support error when deploy Moodle on XAMPP?

Software Required

- macOS High Sierra
- XAMPP-VM/PHP 7.3.0. Please refer to download
- Moodle version 3.6.1

Problem

• During the Moodle installation on XAMPP, mysql_full_unicode_support error message is prompted. Please refer to the screenshot below

• "Barracuda file format" and "full support of UTF-8 on MySql" errors need to be fixed.

Steps

• Locate my.cnf that located at "/opt/lampp/etc/" directory. Insert the configuration as shown below

[client]
default-character-set = utf8mb4

[mysqld]
innodb_file_format = Barracuda
innodb_file_per_table = 1
innodb_large_prefix

character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
skip-character-set-client-handshake

[mysql]
default-character-set = utf8mb4

• Restart MySql server. Done!