Trying to install Perl-Mysql DBD, mysql_config can't be found

Question

Here's the output:

Ian-MacBook-Pro:DBD-mysql-4.011 ianseyer$ sudo Perl Makefile.PL
Can't exec "mysql_config": No such file or directory at Makefile.PL line 76.

Cannot find the file 'mysql_config'! Your execution PATH doesn't seem
not contain the path to mysql_config. Resorting to guessed values!
Can't exec "mysql_config": No such file or directory at Makefile.PL line 454.
Can't find mysql_config. Use --mysql_config option to specify where mysql_config is located
Can't exec "mysql_config": No such file or directory at Makefile.PL line 454.
Can't find mysql_config. Use --mysql_config option to specify where mysql_config is located
Can't exec "mysql_config": No such file or directory at Makefile.PL line 454.
Can't find mysql_config. Use --mysql_config option to specify where mysql_config is located

PLEASE NOTE:

For 'make test' to run properly, you must ensure that the
database user 'root' can connect to your MySQL server
and has the proper privileges that these tests require such
as 'drop table', 'create table', 'drop procedure', 'create procedure'
as well as others.

mysql> grant all privileges on test.* to 'root'@'localhost' identified by 's3kr1t';

You can also optionally set the user to run 'make test' with:

perl Makefile.pl --testuser=username

Can't exec "mysql_config": No such file or directory at Makefile.PL line 454.
Can't find mysql_config. Use --mysql_config option to specify where mysql_config is located
Can't exec "mysql_config": No such file or directory at Makefile.PL line 454.
Can't find mysql_config. Use --mysql_config option to specify where mysql_config is located
Can't exec "mysql_config": No such file or directory at Makefile.PL line 454.
Can't find mysql_config. Use --mysql_config option to specify where mysql_config is located
Failed to determine directory of mysql.h. Use

perl Makefile.PL --cflags=-I

to set this directory. For details see the INSTALL.html file,
section "C Compiler flags" or type

perl Makefile.PL --help

I've researched the issue and tried making a symlink to no avail.

Do I have to compile this myself?

Installing `libmysqlclient-dev` solves the issue in ubuntu. – Naveed Nov 15 '12 at 07:42 — Naveed, Nov 15 '12 at 07:42

score 61 · Answer 1 · edited Mar 20 '18 at 13:36

61

If you installed the mysql server that everybody installs: sudo apt-get install mysql-server (or something like this)

you are missing a few extra files on which the makefile for this perl module depends.

You can try to work around this issue by installing the following package:

sudo apt-get install libmysqlclient-dev

REFERECE: http://cpansearch.perl.org/src/RUDY/DBD-mysql-2.9008/INSTALL.html#configuration

edited Mar 20 '18 at 13:36

Eugen Konkov

22,193
17
108
158

answered Jul 02 '12 at 08:23

99Sono

3,554
27
39

Max OS X equivalent: [`brew`](http://brew.sh/)[`install mysql`](http://stackoverflow.com/a/10855483/3437608) – Cullub Dec 21 '15 at 20:15
3

... or sudo apt-get install libmariadbd-dev – MacMartin Apr 18 '18 at 18:32
@eli's answer worked for me though I was using a docker container, i couldn't find any package named libmysqlclient-dev – jimh Feb 27 '19 at 19:48

score 18 · Answer 2 · answered Jan 13 '14 at 22:03

18

Applying to ubuntu/debian users (I'm running U-12.0.4), it was suggested above that users do:

sudo apt-get install libmysqlclient-dev

But then there is another problem with the maketest portion of the install where the "password: NO" FAILED. To bypass that test, just use force:

sudo cpan -f DBD::mysql

answered Jan 13 '14 at 22:03

Damian Green

633
2
8
13

I like this answer because there are situations where installing the entire mysql-server package is undesirable. – Andrew Meyer Mar 02 '18 at 20:15

score 10 · Answer 3 · answered Jul 20 '12 at 22:55

10

Install the mysql-devel package that pertains to your distro and mysql server version.

answered Jul 20 '12 at 22:55

AaronC

101
1
2

This is the correct answer. Also, please note that if you're using a fork of mysql you have to install the devel package matching that fork and version e.g. `Percona-XtraDB-Cluster-devel-56`. – dr_ Apr 18 '16 at 13:10
At least what it needs with CentOS. Thanks! – BurninLeo Dec 20 '17 at 13:43

score 10 · Answer 4 · answered Mar 13 '14 at 17:29

10

if u r using ubuntu , u can easily install using the below cmd

    sudo apt-get install libdbd-mysql-perl

for more detail check the cpan install.pod consist detail about other Linux flavor

answered Mar 13 '14 at 17:29

made_in_india

2,109
5
40
63

score 4 · Answer 5 · answered Apr 12 '12 at 14:03

4

You just need mysql-server and mysql-devel installed locally so that cpan can build the module, you can probably remove the mysql server afterwards.

answered Apr 12 '12 at 14:03

Jack

41
1

score 3 · Answer 6 · edited Oct 20 '12 at 21:32

If you try to install via CPAN you cannot, as far as I know, set the --mysql_config option directly. And, including the directory containing mysql_config in the PATH environment variable does not seem to help.

However, if you do have the file mysql_config available somewhere, you can do the following to make the install succeed:

ln -s /path/to/mysql_config /usr/local/bin/

Then, remove the symbolic link after the DBD::mysql installation.

The tests during install will still fail, unless you have installed MySQL in some central/default location on your system, but installation will still succeed.

If you do not have mysql_config available, you can get it from a tar.gz download of the MySQL Community Server from mysql.com. It will be located in the bin/ subdirectory of the extracted files. If you want to have MySQL installed on your system, a better option is probably to download the RPMs and install them, or install via the package management system of your OS.

score 3 · Answer 7 · answered Jan 18 '11 at 22:38

3

Find the script mysql_config.pl under your MySQL directory, and run Makefile.PL like:

perl Makefile.PL --mysql_config=/path/to/mysql-5.x.y.zzz/bin/mysql_config.pl

answered Jan 18 '11 at 22:38

mob

117,087
18
149
283

2

What do you do if you don;t want mysql installed on the local machine? – Fuzzy Mar 21 '12 at 19:39
8

I dunno, maybe go watch TV. `DBD::mysql` depends on the MySQL client libraries. – mob Mar 21 '12 at 19:52

score 2 · Answer 8 · answered May 29 '19 at 10:25

2

Try yum install mariadb-devel for CentOS 7 and then run the required Perl module installation such as cpan DBD::mysql

answered May 29 '19 at 10:25

Eranga Atugoda

131
1
6

score 0 · Answer 9 · answered Oct 06 '14 at 12:25

0

I was getting make test errors. This helped me;

perl Makefile.PL  --testuser=bob  --testpass=bobtest

answered Oct 06 '14 at 12:25

PodTech.io

4,874
41
24

score 0 · Answer 10 · answered Sep 24 '21 at 08:46

0

I solved installing libmariadbclient-dev, libmariadb-dev and mariadb-client on debian 9.13

apt install mariadb-client libmariadbclient-dev libmariadb-dev

answered Sep 24 '21 at 08:46

AlbertFont

36
4

Trying to install Perl-Mysql DBD, mysql_config can't be found

10 Answers10

Linked