How to solve mysql_full_unicode_support#File_format moodle installation error

Have you encountered mysql_full_unicode_support#File_format and mysql_full_unicode_support#Large_prefix during installation of Moodle on localhost or a shared host?

Here is a short list of instructions on how to solve it

  1. Make sure you have created an empty Moodle database(Moodle does this automatically during installation)
  2. Open open the table then click on SQL tab on phpmyadmin
  3. Input and run the following SQL statements
set global innodb_file_format = `BARRACUDA`;
set global innodb_large_prefix = `ON`