如何解决 moodle 全新安装问题 mysql_full_unicode_support#File_format 和 mysql_full_unicode_support#Large_prefix [英] How to resolve moodle fresh installation issue mysql_full_unicode_support#File_format and mysql_full_unicode_support#Large_prefix

问题描述

我对 Moodle 很陌生.当我尝试安装这个时，我遇到了这个问题(请参考截图).

I am very new to Moodle. When i am trying to install this i got this issue(Please ref screenshot).

有人可以帮我解决这个问题吗?

Can any one help me regarding this?

提前谢谢你.奥姆卡尔

推荐答案

这是一个很常见的问题，人们经常遇到，甚至我也遇到过.安装 moodle 最新 3.2+ 时，它会检查 MySQL 数据库中是否启用了对 utf8mb4 字符集的支持.默认情况下，这在 MySQL 中不会出现.您需要在 mysql conf 中设置一些参数.

This is very common problem, people often face, even i did face too. When installing moodle latest 3.2+ it checks for enabled support for utf8mb4 charset in MySQL database. This doesn't come by default in MySQL. You need to set few parameters in mysql conf.

在基于 Linux 的系统上，您需要更改 my.cnf.这可能位于/etc/mysql/"中.对 my.cnf 进行如下修改:

On Linux based systems you will want to alter my.cnf. This may be located in '/etc/mysql/'. Make the following alterations to my.cnf:

[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

更改值后，重新启动mysql，现在应该修复错误.

Post changing the values, restart mysql and the error should be fixed now.

请参考以下文档

https://docs.moodle.org/32/en/MySQL_full_unicode_support

https://mathiasbynens.be/notes/mysql-utf8mb4#character-sets

这篇关于如何解决 moodle 全新安装问题 mysql_full_unicode_support#File_format 和 mysql_full_unicode_support#Large_prefix的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！