MySQL Server Initialization Warning: Deprecated Parameters & Security Recommendations

On July 24, 2023, at 05:43:05 UTC, the MySQL server initialization process started. The server version used was MySQL 8.1.0.

A warning was issued regarding the deprecated 'default_authentication_plugin' parameter, which will be removed in a future release. The recommendation is to use the 'authentication_policy' parameter instead.

The server was initializing as process 16984.

Another warning was given regarding the 'utf8' character set, which is currently an alias for UTF8MB3 but will be an alias for UTF8MB4 in a future release. It is advised to consider using UTF8MB4 to avoid ambiguity.

The InnoDB initialization process started at 05:43:05 UTC and ended at 05:43:14 UTC.

A warning was displayed stating that the root user was created with an empty password. It is suggested to disable the '--initialize-insecure' option to address this issue.

Additionally, a warning was issued regarding the deprecated 'mysql_native_password' plugin, recommending the use of 'caching_sha2_password' instead.

The MySQL server initialization process ended at 05:43:42 UTC.