Error "Cannot connect to the database." between MariaDB and Zabbix 4.4.7

[migmig1]

I have faced issue with connectivity between maria DB and Zabbix after fresh install of Zabbix . below error happened after starting portal config.

Unsupported charset or collation for tables: users, maintenances, hosts, hstgrp, screens_items, group_prototype, group_discovery, slideshows, applications, slides, drules, dchecks, httptest, httpstep, interface, valuemaps, operations, media_type_param, media_type, usrgrp, actions, opmessage, opconditions, conditions, config, triggers, functions, graphs, hostmacro, graphs_items, graph_theme, globalmacro, mappings, icon_mapping, media, services, services_times, icon_map, sysmaps, sysmaps_elements, sysmaps_links, alerts, expressions, sysmap_element_url, sysmap_url, regexps, acknowledges, widget, ids, history_str, history_log, history_text, proxy_history, proxy_dhistory, events, auditlog, auditlog_details, autoreg_host, proxy_autoreg_host, dservices, host_inventory, housekeeper, images, item_discovery, host_discovery, profiles, sessions, event_tag, item_condition, item_rtdata, application_prototype, sysmap_shape, application_discovery, trigger_tag, problem, problem_tag, tag_filter, httptest_field, correlation, corr_condition_tagpair, host_tag, httpstep_field, dashboard, task_remote_command, item_preproc, maintenance_tag, lld_macro_path, config_autoreg_tls, screens, items, scripts, opcommand, sysmaps_link_triggers, corr_condition_tag, corr_condition_tagvalue, task_remote_command_result, widget_field.

Please let me know about your comments about this case:

[tim.mooney]

Unsupported charset or collation

Since this is a fresh install of Zabbix, you should review the steps on creating the database and then recreate it with correct settings for character set and collation. The database setup is covered in the chapter on installation.

[migmig1]

thanks for response, i have tried all the ways but still same issue happened.

[tim.mooney]

Connect to your zabbix database using the mysql command line client, including the additional command line parameters for '--silent' and '--raw', which when used together remove the boxes around columns but preserve some other formatting:

mysql -u REPLACE_THIS_WITH_YOUR_ZABBIX_DATABASE_USERNAME --database=REPLACE_THIS_WITH_YOUR_ZABBIX_DATABASE_NAME --silent --raw -p

and then once you're connected to the database, type

 show create table users;

Post the output from that here, so we can see what COLLATE and DEFAULT CHARSET are getting set to.