Problem with pip install mariadb - mariadb_config not found

Question

I have been trying to run pip3 install mariadb on my raspberry pi running ubuntu 18.04 and I was unsuccessful.

I have tried installing following packages as suggested in other answers:

sudo apt-get install mariadb-server
sudo apt-get install libmariadbclient-dev
sudo apt-get install libmysqlclient-dev

pip3 install mysqlclient
pip3 install mysql-connector-python-rf

However, I'm still running intto the problem as shown:

ubuntu@ubuntu:~$ pip3 install mariadb
Collecting mariadb
  Using cached https://files.pythonhosted.org/packages/8f/c9/7050899dc1066409a17e1147d3afe1b078e582afdb755c6d3cb9c9a5c3ab/mariadb-1.0.0.tar.gz
    Complete output from command python setup.py egg_info:
    /bin/sh: 1: mariadb_config: not found
    Traceback (most recent call last):
      File "<string>", line 1, in <module>
      File "/tmp/pip-build-2gdw_t_r/mariadb/setup.py", line 26, in <module>
        cfg = get_config(options)
      File "/tmp/pip-build-2gdw_t_r/mariadb/mariadb_posix.py", line 49, in get_config
        cc_version = mariadb_config(config_prg, "cc_version")
      File "/tmp/pip-build-2gdw_t_r/mariadb/mariadb_posix.py", line 27, in mariadb_config
        "mariadb_config not found.\nPlease make sure, that MariaDB Connector/C is installed on your system, edit the configuration file 'site.cfg' and set the 'mariadb_config'\noption, which should point to the mariadb_config utility.")
    OSError: mariadb_config not found.
    Please make sure, that MariaDB Connector/C is installed on your system, edit the configuration file 'site.cfg' and set the 'mariadb_config'
    option, which should point to the mariadb_config utility.
    
    ----------------------------------------
Command "python setup.py egg_info" failed with error code 1 in /tmp/pip-build-2gdw_t_r/mariadb/

I do have /etc/mysql/my.cnf file.

Pablompg · Answer 1 · 2021-04-30T18:45:45.863

57

You probably need to install MariaDB database development files: https://packages.debian.org/unstable/libmariadb-dev. You need this package for your python connector to work properly in linux. You need to follow this steps:

sudo apt-get update -y
sudo apt-get install -y libmariadb-dev
pip3 install mariadb

Here you are first updating the list of packages that need an upgrade for your system. Then you are installing the previously mentioned dev library. The last step is to install mariadb with pip3 which should now work as expected.

edited Apr 30 '21 at 18:45

answered Aug 09 '20 at 12:51

Pablompg

699
4
8

This did not work for me – Nuwan Abeynayake Feb 07 '22 at 06:31
If you share what error messages you are getting we might be able to help you – Pablompg Feb 13 '22 at 11:35
Mariadb's website instructions - did not work. Multiple guides - did not work. This comment - worked. – Trent Yarosevich Mar 04 '22 at 00:57
Got a funny error "invalid command 'bdist_wheel'" and then "ERROR: Failed building wheel for mariadb"... but then it finished with "Successfully installed mariadb-1.0.11". – mike rodent May 22 '22 at 17:15

score 7 · Answer 2 · answered Jan 31 '22 at 15:50

7

On a Mac you need to first install mariadb-connector-c which can be done using brew:

brew install mariadb-connector-c

Then you can install mysqlclient:

pip3 install mysqlclient

answered Jan 31 '22 at 15:50

Pierz

7,064
52
59

score 2 · Accepted Answer · answered Jul 22 '20 at 12:20

It looks like that you didn't install MariaDB Connector/C properly, on Ubuntu mariadb_config should be found in /usr/bin.

Please also note, that MariaDB Connector/Python requires MariaDB Connector/C 3.1.5 or newer, afaik Ubuntu 18.04 provides 3.0.3 - so simplest way would be to download the Connector/C sources and build it manually.

score 0 · Answer 4 · answered Jun 04 '23 at 07:57

For Debian 11 you can do the following, if you don´t want to update MariaDB to the latest version:

sudo apt-get update -y
sudo apt-get install -y libmariadb-dev
pip install mariadb==1.0.11

Newer versions of MariaDB driver will not work out of the box.

score 0 · Answer 5 · answered Aug 29 '23 at 14:23

For Debian , if you want to install mariadb >= 1.1.2 you need to build from source :

sudo apt install git gcc make cmake libssl-dev
git clone https://github.com/MariaDB/mariadb-connector-c.git
mkdir build && cd build
cmake ../mariadb-connector-c/ -DCMAKE_INSTALL_PREFIX=/usr
make
sudo make install

original answer: here

Problem with pip install mariadb - mariadb_config not found

5 Answers5

Linked