Good morning.
First of all I would like to clarify that I really do not know much about these issues. I installed XAMPP in Windows and I'm installing Moodle . In Moodle I get the following errors:
mysql_full_unicode_support # File_format
"Your database has tables using Antelope as the file format. Full UTF-8 support in MySQL and MariaDB requires the Barracuda file format. Please convert the tables to the Barracuda file format. See the documentation Administration via command line for details of a tool for converting InnoDB tables to Barracuda. "
and
mysql_full_unicode_support # Large_prefix
"For full support of UTF-8 both MySQL and MariaDB require you to change your MySQL setting 'innodb_large_prefix' to 'ON'. See the documentation for further details."
Following the instructions of moodle referred to in this link , I open the console with the option "Run as administrator "but I do not accept the given instruction. I have the instruction like this:
C:/xampp/htdocs/moodle/admin/cli>php /mysql_compressed_rows.php -l
And he returns me
Could not open input file: mysql_compressed_rows.php
On the other hand I tried it with MySql starting with mysql -u root and with the instruction SET GLOBAL . At first it worked for me, but when restarting XAMPP it does not keep the changes made.
They tell me that it may be a matter of permission but I do not know how or where to manage them. Also with the mysql I do not understand why it resets the changes made when restarting XAMPP. I really appreciate the help you can give me.