mysql_config not found when installing mysqldb python interface for mariadb 10 Ubuntu 13.10

Question

After I installed Mariadb 10 the Mysql workbench and JPDB client both connect and work fine so next step was get programming with Python (using SQLAlchemy) which seems to require MySQL-python so I went to update that and got: "mysql_config not found" I looked in the "usual places" and did not see a file...

So I followed some ideas from an earlier question on SO and tried to install: apt-get install libmysqlclient-dev

which got me to: The following packages have unmet dependencies: libmysqlclient-dev : Depends: libmysqlclient18 (= 5.5.35-0ubuntu0.13.10.2) but 10.0.10+maria-1~saucy is to be installed

which kind of hits a brick wall for me

Answer 1

For Centos 7.0 install the following:

yum install mariadb-devel

For Fedora 23+:

dnf install mariadb-devel

Answer 2

Found it! The case is that mariadb has a compatible package, if you have the ppa setup as in http://downloads.mariadb.org/. Just

sudo apt-get install libmariadbclient-dev

Thanks to http://data-matters.blogspot.com/2013/08/install-mysql-python-with-mariadb.html After this the mysql-python installs correctly

Answer 3

There's NO solution on Ubuntu 16.04

Doing:

sudo ln -s /usr/bin/mariadb_config /usr/bin/mysql_config

Worked for me.

Answer 4

Install the following library:

sudo apt-get install libmariadb-client-lgpl-dev  

And create a symbolic link named mysql_config:

ln -s /usr/bin/mariadb_config /usr/bin/mysql_config

Answer 5

For Debian/Ubuntu PPA from https://downloads.mariadb.org/mariadb/repositories/

for MariaDB 10.1: apt-get install libmariadbclient-dev
for MariaDB 10.2: apt-get install libmariadb-dev
for MariaDB 10.3: apt-get install libmariadb-dev-compat

Answer 6

On Ubuntu 17.04 the following worked for me

sudo apt-get install default-libmysqlclient-dev