[Server] unknown variable 'query_cache_limit=64M'
[Server] unknown variable 'query_cache_size=256M'
[Server] unknown variable 'query_cache_type=1'
[Server] The privilege system failed to initialize correctly. If you have upgraded your server, make sure you're executing mysql_upgrade to correct
the issue.
MySQL 8+ unknown variable query_cache_limit query_cache_size query_cache_type
MySQL system variables query_cache_limit, query_cache_size, query_cache_type were removed in MySQL 8.0.3, remove them from your MySQL configuration file, otherwise MySQL won't get successfully started.
Another change is that in MySQL 8+ it is prohibited to start the server with a lower_case_table_names setting that is different from the setting used when the server was initialized. The restriction is necessary because collations used by various data dictionary table fields are based on the setting defined when the server is initialized, and restarting the server with a different setting would introduce inconsistencies with respect to how identifiers are ordered and compared. |
