Support for MySQL 8.0
ProxySQL supports MySQL 8.0 , although there are some limitations:
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 yet support
For this reason, the MySQL server needs to be configured using
mysql_native_password. See the doc for further details.
ProxySQL doesn’t accept connections (frontend connections and connections to Admin) if the client tries to use the
caching_sha2_passwordauthentication plugin. If clients are using libmysqlclient from MySQL 8.0 (that defaults to
caching_sha2_password), they must explicitly use
You can specify
my.cnfin the section
[client], or specify it on the command line.
For example, to connect to Admin:12mysql --default-auth=mysql_native_password -h 127.0.0.1 -P6032 -u admin -padmin
Both notes above are not valid anymore for recent versions of ProxySQL 2.0