异常

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

Parents
  • 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.

Reply
  • 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.

Children
No Data