Question how config mariandb for utf8mb4

[shinichi kudo]

while installing moodle it aask about this warning:

mysql_full_unicode_support

if this test fails, it indicates a potential problem The current setup of MySQL or MariaDB is using 'utf8'. This character set does not support four byte characters which include some emoji. Trying to use these characters will result in an error when updating a record, and any information being sent to the database will be lost. Please consider changing your settings to 'utf8mb4'. See the documentation for full details.

how i do it ?

 

[IgorG]

I think that you need to upgrade MySQL or MariaDB to a higher version 10.x, where 'utf8mb4' collation is present by default.

 

[shinichi kudo]

I USE

Plesk Obsidian
Version 18.0.39 Update #1

with
Mariadb 10.5

and i edit the my.ini like this

[client]
port=8306
default-character-set=utf8mb4
plugin_dir=C:\\path\\to\\plesk\\MySQL\\lib\\plugin
[PleskSQLServer]
port=8306
character-set-server=utf8mb4
default-storage-engine=INNODB
query_cache_size=8M
table_open_cache=32
tmp_table_size=7M
thread_cache_size=32
myisam_max_sort_file_size=100G
myisam_sort_buffer_size=2M
key_buffer_size=2M
read_buffer_size=1M
read_rnd_buffer_size=256K
sort_buffer_size=256K
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=1M
innodb_buffer_pool_size=16M
innodb_log_file_size=10M
max_connections=300
max_allowed_packet=1M
net_buffer_length=4K
old_passwords=0
connect_timeout=20
basedir=C:\\path\\to\\plesk\\MySQL
datadir=C:\\path\\to\\plesk\\MySQL\\Data
tmpdir=C:\\path\\to\\plesk\\MySQL\\Data

[mysqld]
innodb_file_format = Barracuda
innodb_file_per_table = 1
innodb_large_prefix = true
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
skip-character-set-client-handshake = FALSE
init_connect = "SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci"

[mysql]
default-character-set = utf8mb4

want to know also if i want to use the maria shell what is the password i have to use