MySQL 8.0

René Cannaò edited this page Jul 4, 2018 · 2 revisions

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 
You can’t perform that action at this time.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.
Press h to open a hovercard with more details.