Hello, I am very new to the DBI module. I am trying to connect to a mysql installation on a server over the internet, however I cannot get the DBD::mysql driver installed properly. When I try to install via CPAN with the command 'sudo -H cpan -i DBD::mysql' I get the error:
CPAN: Storable loaded ok (v2.18) Going to read /var/root/.cpan/Metadata Database was generated on Tue, 06 Apr 2010 13:34:47 GMT CPAN: YAML loaded ok (v0.71) Going to read /var/root/.cpan/build/ ............................................................................DONE Found 16 old builds, restored the state of 16 Running install for module 'DBD::mysql' Running make for C/CA/CAPTTOFU/DBD-mysql-4.013.tar.gz Has already been unwrapped into directory /var/root/.cpan/build/DBD- mysql-4.013-CoqaqX '/usr/bin/perl Makefile.PL' returned status 512, won't make Running make test Make had some problems, won't test Running make install Make had some problems, won't install Has anybody encountered this and know a workaround? I could not get a manual install to work either, although I will admit I don't have any previous experience doing a manual install. I tried to follow the instructions on the DBD::mysql module page have been reading this group and searching for solutions online but nothing has worked. When I try a manual install i get the message: PLEASE NOTE: For 'make test' to run properly, you must ensure that the database user 'robertmulley' 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 'robertmulley'@'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 464. 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 464. 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 464. 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 I have MAMP installed and running. Also I don't care about connecting to localhost, is there a way to run the drop table tests ect on a server over the internet? Thanks.