I've been working on getting DBD:mysql installed on my Mac for about 20 hours now. I've tried almost everything that I could find online and nothing seems to be working. I'm running OS X and I have MySQL installed as part of XAMPP. Can someone help me find a solution to this?

It might help to know that I had NO IDEA even what Terminal was before starting this, so assume I don't know a single thing about Mac, Terminal, Perl, anything. I'm simply trying to execute prewritten Perl scripts that need DBI and DBD:mysql to function.

I have downloaded the latest DBD-mysql and placed the folder into my '/System/Library/Perl/' folder. In Terminal, I typed in 'cd /System/Library/Perl/' to get into the directory and it works. I then type in 'sudo Makefile.PL' and I get this error:

Code

Can't exec "mysql_config": No such file or directory at Makefile.PL line 83.

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 479. 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 479. 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 479. 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 'Mac' 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 'Mac'@'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 479. 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 479. 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 479. 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<dir>

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

perl Makefile.PL --help Wades-MacBook-Pro:DBD-mysql-

I've also tried pointing to the mysql_config file directly and it says this: