异常

by Jun 17, 2021

如何解决Aqua Data Studio连接MySQL 8.0出现的问题:Unknown system variable 'query_cache_size'?

Response

Thomas Conrad over 1 year ago
Hello,

The query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL 8.0.
dev.mysql.com/…/added-deprecated-removed.html

Interestingly, some users say that using the driver version 5.1.44 or newer fixed the problem.
Aqua Data Studio version 22.0 is using driver version 5.1.49. What version of Aqua Data Studio are you using?
The driver version used by Aqua Data Studio can be found by right clicking on the connection and selecting Server
Support Information. This also contains the MySQL server version.