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

score 39 · Answer 1 · edited Dec 03 '16 at 18:24

39

For Centos 7.0 install the following:

yum install mariadb-devel

For Fedora 23+:

dnf install mariadb-devel

edited Dec 03 '16 at 18:24

icc97

11,395
8
76
90

answered Aug 21 '14 at 15:34

anonymous

399
3
3

3

the question pertains to Ubuntu, not Centos 7.0. – drs Aug 21 '14 at 15:38
9

@drs Never the less this answer is useful as this question shows up for generic linux searches – icc97 Dec 03 '16 at 18:25
Why does a package by the name mariadb-devel contain mysql development libraries? – hungryWolf Aug 15 '18 at 00:44

score 35 · Accepted Answer · edited Jan 10 '17 at 04:12

35

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

edited Jan 10 '17 at 04:12

elprup

1,960
2
18
32

answered Apr 08 '14 at 22:59

dartdog

10,432
21
72
121

This is a solution to install libraries depend on mysql-dev on ubuntu. Thanks. – Robert Moon Dec 18 '15 at 06:39
You can also just install 'libmariadbclient-dev' from Ubuntu, without the need for the custom ppa. – GrayB Dec 18 '15 at 17:31
1

Worked for Ubuntu 18.04, however for Mac Mojave I had to do `brew install mysql-connector-c` – Bishwas Mishra May 12 '19 at 19:11

score 22 · Answer 3 · edited May 10 '16 at 13:30

22

There's NO solution on Ubuntu 16.04

Doing:

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

Worked for me.

edited May 10 '16 at 13:30

Gustavo Morales

2,614
9
29
37

answered May 10 '16 at 12:47

Christian Jürges

221
2
2

Best answer for Ubuntu 16.04 ! – Mat'arangéÇa Sep 08 '17 at 21:03
This fixed the same issue on debian buster – maxisme Jun 30 '19 at 14:45

Kenly · Answer 4 · 2016-10-21T15:18:25.957

9

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

edited Oct 21 '16 at 15:18

answered Oct 13 '16 at 13:33

Kenly

24,317
7
44
60

This was it. Something is rotten in the state of ubuntu 16 – MagicLAMP Jul 30 '17 at 11:36

score 7 · Answer 5 · answered Oct 09 '18 at 10:18

7

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

answered Oct 09 '18 at 10:18

Dmitry Mottl

842
10
17

Thanks! This one is really helpful! – skabbit Jan 09 '22 at 14:13

score 3 · Answer 6 · answered Jun 22 '17 at 17:46

3

On Ubuntu 17.04 the following worked for me

sudo apt-get install default-libmysqlclient-dev

answered Jun 22 '17 at 17:46

f0xik

101
5

Worked for me on debian as well – Gadzair Sep 05 '19 at 05:26

score 2 · Answer 7 · answered Nov 23 '16 at 06:40

2

For Debian Jessie:

sudo apt-get install libmariadb-client-lgpl-dev 
sudo ln -s /usr/bin/mariadb_config /usr/bin/mysql_config

answered Nov 23 '16 at 06:40

Simha

149
3
9

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

7 Answers7

Linked