MySQL Server Initialization Log - Warnings and Deprecation Notices

This log shows the initialization process of a MySQL server. Here's a breakdown of the key events:\n\n- [System] [MY-015017] [Server] MySQL Server Initialization - start: This indicates that the initialization process has begun.\n- [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead: This is a warning message informing that the 'default_authentication_plugin' setting will be deprecated and suggests using 'authentication_policy' instead.\n- [System] [MY-013169] [Server] E:\mysql-8.1.0-winx64\bin\mysqld.exe (mysqld 8.1.0) initializing of the server in progress as process 16984: This shows the path and version of the MySQL server being initialized.\n- [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: This warning suggests using the character set UTF8MB4 instead of UTF8MB3 in order to avoid ambiguity in future releases.\n- [System] [MY-013576] [InnoDB] InnoDB initialization has started: This indicates the initialization of the InnoDB storage engine has begun.\n- [System] [MY-013577] [InnoDB] InnoDB initialization has ended: This signifies the completion of the InnoDB initialization process.\n- [Warning] [MY-010453] [Server] root@localhost is created with an empty password! Please consider switching off the --initialize-insecure option: This warning suggests that the root user has been created without a password and advises disabling the '--initialize-insecure' option for better security.\n- [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead': This warning message suggests using the 'caching_sha2_password' plugin instead of 'mysql_native_password' as it will be deprecated in the future.\n- [System] [MY-015018] [Server] MySQL Server Initialization - end: This indicates the completion of the MySQL server initialization process.\n\nOverall, the log provides information about the deprecation of certain settings, the initialization of InnoDB, and warnings regarding password security and plugin deprecation.