Свежеустановленный bitrix-env 7.5.0. Установлен сразу с mysql 8.
БУС бизнес, демо-магазин.
[CODE]2021-Aug-19 08:52:10 Кодировка соединения (check_mysql_connection_charset): Fail
character_set_connection=utf8mb3, collation_connection=utf8_general_ci, character_set_results=utf8mb3
Ошибка! Кодировка соединения с базой данных должна быть utf8, текущее значение: utf8mb3
[/CODE]
Учитывая, что utf8 это псевдоним для utf8mb3, можно на эту ошибку не обращать внимания.
[CODE][System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25-15) starting as process 3164
[Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
[Warning] [MY-013244] [Server] --collation-server: 'utf8_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
[/CODE]
Скрытый текст |
|---|
[CODE]cat /etc/my.cnf
# Database charset parameters
character-set-server = utf8
collation-server = utf8_unicode_ci
init-connect = "SET NAMES utf8 COLLATE utf8_unicode_ci"
[/CODE]
[CODE]mysql> show variables\G
*************************** 54. row ***************************
Variable_name: character_set_client
Value: utf8mb3
*************************** 55. row ***************************
Variable_name: character_set_connection
Value: utf8mb3
*************************** 56. row ***************************
Variable_name: character_set_database
Value: utf8mb3
*************************** 57. row ***************************
Variable_name: character_set_filesystem
Value: binary
*************************** 58. row ***************************
Variable_name: character_set_results
Value: utf8mb3
*************************** 59. row ***************************
Variable_name: character_set_server
Value: utf8mb3
*************************** 60. row ***************************
Variable_name: character_set_system
Value: utf8mb3
*************************** 61. row ***************************
Variable_name: character_sets_dir
Value: /usr/share/percona-server/charsets/
*************************** 63. row ***************************
Variable_name: collation_connection
Value: utf8_general_ci
*************************** 64. row ***************************
Variable_name: collation_database
Value: utf8_unicode_ci
*************************** 65. row ***************************
Variable_name: collation_server
Value: utf8_unicode_ci
*************************** 74. row ***************************
Variable_name: default_collation_for_utf8mb4
Value: utf8mb4_0900_ai_ci
*************************** 137. row ***************************
Variable_name: init_connect
Value: SET NAMES utf8 COLLATE utf8_unicode_ci
[/CODE] |
