MySQL 8.0

Please note: the project WIKI documentation has been moved to the ProxySQL website

---

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.
   You can specify default-auth=mysql_native_password in my.cnf in the section[mysql] or [client], or specify it on the command line.
   For example, to connect to Admin:

mysql --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