MySQL 8.0

Support for MySQL 8.0

ProxySQL supports MySQL 8.0 , although there are some limitations:

1. starting with MySQL 8.0.4, the default authentication plugin for MySQL server was changed from mysql_native_password to caching_sha2_password. ProxySQL doesn't support yet caching_sha2_password. For this reason, MySQL server needs to be configured using mysql_native_password. See the doc for further details.
2. ProxySQL doesn't accept connections (frontend connections and connections to Admin) if the client tries to use caching_sha2_password authentication plugin. If clients are using libmysqlclient from MySQL 8.0 (that defaults to caching_sha2_password), they must explicitly use mysql_native_password. For example, to connect to Admin:

mysql --default-auth=mysql_native_password -h 127.0.0.1 -P6032 -u admin -padmin