Linux mysql-server cannot find mysql_config

Question

I have an executable (in production) instance of mysql on my Linux server (ubuntu-10.10), however I cannot find the mysql_config file.

command and output:

~$ locate mysql_config ~$ 

I heard / read that I need to install the libmysqlclient-dev package in order to use mysql_config, but I don't want to break the current current instance. I want to make sure that installing this dev package will not affect my current mysql databases.

Also, where can I find the initial download for libmysqlclient-dev for manual installation? In my current situation (behind a corporate proxy), I am not allowed to use apt-get.

UPDATE

this is due to an attempt to install python-MySQLdb from the source. the setup.py file requires the mysql_config path and continues to fail when trying to use anything other than this file.

Answer 1

The mysql_config executable is by default located in the bin directory of the MySQL server installation if you install it from precompiled binaries. But if you install it using apt-get , it may not exist on your server.

Try:

 sudo apt-get install libmysqlclient-dev 

Answer 2

In a Ubuntu 13.04 installation, it is located in /usr/bin/mysql_config

Answer 3

Try / etc / my.cnf, this is the standard file for mysql configuration.

Answer 4

You can also do:

 find / -name my.cnf -type f 

Answer 5

In Fedora, install the mariadb-devel , and you must have a binary.

Answer 6

yum install mariadb-devel also works for Centos 7, this puts mysql_config in all the places pip install mysqlclient requires / searches for.