Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Make Proxysql2 work with default PXC settings

Description

Hello
I installed PXC 8.0 and proxysql2 from percona packages.
after create user x@y identified by "password" in mysql
and proxysql-admin --syncusers I can't connect to PXC via proxysql

Workaround: create/alter user using
identified WITH 'mysql_native_password' by "password"

So proxysql2 and/or proxysql-admin are not able to use 
IDENTIFIED WITH 'caching_sha2_password' which pxc 8.0 uses by default.

I'm aware of that this might be a proxysql2 problem or a mysql8 one,
and that default_authentication_plugin can set to mysql_native_password
proxysql_admin is aware of it as the monitoring user is created that way
by proxy-admin --enable 

Expected behaviour:
Best way : make it work with caching_sha2_password
Alternative: give an error message on --syncusers if caching_sha2_password is used
Alternative: update the documentation on this point. 
Alternative: use default_authentication_plugin  = mysql_native_password as long it does not work with caching_sha2_password

 

 

Environment

ubuntu 18.04 LTS
percona repos

Smart Checklist

Activity

Show:

Lalit Choudhary May 22, 2020 at 10:28 AM

Since this behavior already documented, closing this report.

Lalit Choudhary May 22, 2020 at 10:27 AM

 Hi

Thank you for the report and the alternatives. 

This change coming from MySQL8 as caching_sha2_password plugin is default authentication plugin. 

I would best solution here is to add following in my.cnf  before starting pxc8 node.
 

[mysqld] default-authentication-plugin=mysql_native_password

Alternatives:

1. The above setting could be the part of default my.cnf file generated after PXC package installation. 

But this change already documented in Percona proxysql-admin tool documentation.

https://www.percona.com/doc/percona-xtradb-cluster/LATEST/howtos/proxysql-v2.html#syncusers

 

Important

This option does not work if the Percona XtraDB Cluster user is created using the caching_sha2_password plugin (used by default in Percona XtraDB Cluster 8.0). Create a mysql user using the mysql_native_password authentication plugin.

Not a Bug

Details

Assignee

Reporter

Affects versions

Priority

Smart Checklist

Created May 20, 2020 at 12:52 PM
Updated March 6, 2024 at 9:31 PM
Resolved May 22, 2020 at 10:28 AM
Configure

Flag notifications