Assistance with installing mysql_config_editor

I need to configure encrypted password files using mysql_config_editor but does not seem to be available within the install files I used for XtraDB Cluster. Apparently it is available with the default Mysql Client install. know this is not a Percona product but was wondering if anyone had experience with this. I tried the following:

apt install mysql-client-5.7

Reading package lists… Done
Building dependency tree
Reading state information… Done
Package mysql-client-5.7 is a virtual package provided by:
percona-xtradb-cluster-client-5.7 5.7.34-31.51-1.buster
percona-server-client-5.7 5.7.35-38-1.buster
You should explicitly select one to install.

E: Package ‘mysql-client-5.7’ has no installation candidate
root@iaddb01:~# wget http://dev.mysql.com/get/Downloads/MySQL-5.6/libmysqlclient-dev_5.6.21-1ubuntu14.04_i386.deb
–2021-10-04 20:07:54-- http://dev.mysql.com/get/Downloads/MySQL-5.6/libmysqlclient-dev_5.6.21-1ubuntu14.04_i386.deb

1 Like

Hi Mikem, mysql_config_editor is provided by the percona-server-client package. Do you have that installed?

1 Like

I do not have this installed but when I tried the install it said the xtradb-cluster-client and xtradb-cluster-server would be removed. I would have thought this would be included in one these two.

1 Like

sorry my bad, try percona-xtradb-cluster-client instead

1 Like

I have/had percona-xtradb-cluster-client installed but cannot find the mysql_config_editor binary. I performed a search of the file system but cannot seem to locate this.

root@db-app01-atl-dev:/# apt list --installed | grep percona

WARNING: apt does not have a stable CLI interface. Use with caution in scripts.

percona-release/unknown,unknown,now 1.0-27.generic all [installed]
percona-xtrabackup-80/unknown,now 8.0.25-17-1.bionic amd64 [installed,upgradable to: 8.0.26-18-1.bionic]
percona-xtradb-cluster-client/unknown,now 1:8.0.23-14-1.bionic amd64 [installed]
percona-xtradb-cluster-common/unknown,now 1:8.0.23-14-1.bionic amd64 [installed]
percona-xtradb-cluster-server/unknown,now 1:8.0.23-14-1.bionic amd64 [installed]

1 Like

Ok, seems there is a missing dependency for the client package. Try this:
apt-get install libperconaserverclient20-dev

1 Like

That did it, thanks!

1 Like