找回密码
 新建账号

MySQL unknown variable query_cache_limit query_cache_size query_cache_type

[复制链接]
php 发表于 2018/4/28 15:02 | 显示全部楼层 |阅读模式
[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.

手机版|轻松E站

GMT+8, 2024/3/19 14:59

快速回复 返回顶部 返回列表