Unable to use mysqldump to dump proxysql configuration - issue?

[newbie2allthingsdev]

Hello!

I got an error when using mysqldump to export proxysql configuration (specifically mysql_servers) from proxysql:

-sh-4.2$ mysqldump -u myuser -p -h 127.0.0.1 -P6032 --no-tablespaces --replace --skip-triggers -t main mysql_servers > /tmp/dump_servers.sql
Enter password: 
mysqldump: Couldn't execute '/*!80000 SET SESSION information_schema_stats_expiry=0 */': ProxySQL Admin Error: not an error (1045)

There was no error in proxysql.log (which makes sense since it said "ProxySQL Admin Error: not an error (1045)")

All servers having ONLINE status. I can connect using
mysql -h 127.0.0.1 -P 6032 -u myuser -p -e 'show tables'
and get result.

Mysql client is 8.0.17. Proxysql version is 2.0.6-73-gc746bf7. There are 3 nodes in the proxysql cluster.

I was able to do the same mysqldump command on a proxysql cluster with version 2.0.5 and mysql client 5.7.26. Is it something I am not doing right on the 2.0.6 cluster, or is this a bug?

I first read about using mysqldump to export proxysql configurations here: https://github.com/sysown/proxysql/issues/392

Thank you for your help!

[newbie2allthingsdev]

Update, I uninstalled mysql 8.0.17 client (just the client, not libs/libs-compat/common) and installed mysql 5.7.26 client, and mysqldump worked right away without any issue.

[renecannao]

From version 2.0.8 you will be able to use mysqldump version 8.0 .
Details in the wiki
Thank you