Ubuntu – thesql_config_editor not included in MySQL APT Repository

14.04MySQL

I've installed MySQL from MySQL APT Repository. Now I want to run "mysql_config_editor" to encrypt my .mylogin.cnf, but it displays:

The program 'mysql_config_editor' is currently not installed. To run 'mysql_config_editor' please ask your administrator to install the package 'mysql-client-5.6'

I could install mysql-client-5.6, but then it uninstalls my MySQL APT Repository packages and replaces with older, "Ubuntu original" packages.

Can I just extract mysql_config_editor binary from mysql-client-5.6 deb package, or maybe it's not a good idea? And why this binary isn't in MySQL APT Repository?

Best Answer

The easiest way:

apt-get install libmysqlclient-dev

Related Solutions

Ubuntu – Installing MySQL 5.6 using PPA

Just run the following commands:

apt-get -y remove mysql-server
apt-get -y autoremove
apt-get -y install software-properties-common
add-apt-repository -y ppa:ondrej/mysql-5.6
apt-get update
apt-get -y install mysql-server

Ubuntu – How install or uninstall half-installed thesql-client-5.6 on/from ubuntu 15.10

I had the same issue on VM with Ubuntu 14.04. The only thing worked for me is similar to what Richard Uijen has suggested:

sudo apt-get --purge remove mysql*
sudo apt-get autoremove mysql*
sudo rm -rf /etc/mysql/
sudo rm -rf /var/lib/mysql/
sudo apt-get clean
sudo apt-get update
sudo apt-get install --reinstall mysql-client-5.6

Basically you need to remove all mysql packages (mysql*), clean and install again

After that I could install php7 mysql client without any issues

sudo apt-get install libapache2-mod-php7.0 php7.0-mysql

Best Answer

Related Solutions

Ubuntu – Installing MySQL 5.6 using PPA

Ubuntu – How install or uninstall half-installed thesql-client-5.6 on/from ubuntu 15.10

Related Question