XWiki expects the database to use utf8 or utf8mb4 encoding with collation *_bin and it's highly recommended to use utf8mb4 (and utf8mb4_bin) which is the default since MySQL 8. See Database support strategy for the supported versions.

MySQLSynta圎rrorException: Row size too large (> 8126).

'Incorrect string value' error with MySQL connector 8.0.29+.

Convert a database to utf8mb4/utf8mb4_bin.

MySQL versions older than 5.7 and utf8mb4.

We've installed your MySQL database without a root password.

Warning: The post-install step did not complete successfully You can remove all files that the server added to it. T07:38:33.901397Z 0 The designated data directory /usr/local/var/mysql/ is unusable. T07:38:33.901388Z 0 -initialize specified but the data directory has files in it. Please consider using UTF8MB4 in order to be unambiguous. T07:38:33.900625Z 0 -character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. usr/local/Cellar/mysql/8.0.32/bin/mysqld Last 15 lines from /Users/chenfubao/Library/Logs/Homebrew/mysql/post_install.01.mysqld: => /usr/local/Cellar/mysql/8.0.32/bin/mysqld -initialize-insecure -user=chenfubao -basedir=/usr/local/Cellar/mysql/8 => Pouring protobuf-21.12.big_sur.bottle.1.tar.gz

=> Installing mysql dependency: Pouring Downloading 🍺 /usr/local/Cellar/ca-certificates/: 3 files, 216.9KB => Regenerating CA certificate bundle from keychain, this may take a while. => Installing mysql dependency: ca-certificates => Installing dependencies for mysql: icu4c, ca-certificates, libcbor, libfido2, lz4, protobuf, zlib, xz and zstd => Fetching dependencies for mysql: icu4c, ca-certificates, libcbor, libfido2, lz4, protobuf, zlib, xz and zstd 执行下载命令 brew install opt % brew install 8.0.27_1 is already installed but outdated (so it will be upgraded). Sudo rm -rf /Library/StartupItems/MySQLCOM

Mysql 5.7 download for mac