docker 8.4.0 swarm deploy start error: Data Dictionary initialization failed. about mysql HOT 6 CLOSED

8.4.0 in now equal to 8.4.0-oraclelinux9. 8.4.0-oraclelinux8 will likely receive no further updates. Currently there is no plan to maintain both the Oracle Linux 8 and Oracle Linux 9 variants, just OL9. But that could change: #1055 (comment).

from mysql.

chown -R 999:999

because:

[root@localhost data]# docker run -i mysql:8.4.0 id mysql
uid=999(mysql) gid=999(mysql) groups=999(mysql)

from mysql.

mysql.cnf

[client]
port = 3306
default-character-set = utf8mb4

[mysql]
port = 3306
default-character-set = utf8mb4

[mysqld]
#bind-address = 0.0.0.0
#port = 3306
max_connections = 10000
max_user_connections= 1000

#log
log_error=/var/log/mysql/mysql_error.log
general_log_file=/var/log/mysql/mysql.log
general_log=0 
slow_query_log=1
slow_query_log_file=/var/log/mysql/mysql_slow.log
long_query_time=1
log_queries_not_using_indexes=0

##########################
# character set
##########################
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci

from mysql.

same here

from mysql.

See #1056, #1058, and #1060, at least one of which this is definitely a duplicate of.

from mysql.

@tianon Try 8.4.0-oraclelinux8 and it does start successfully. But I would like to ask what is the difference from 8.4.0 tag? 8.4.0-oraclelinux8 is recommended for production use?
via: #1060 (comment) #1058 (comment)

from mysql.