i have followed the INSTALL file instruction in MySQL source which i download it from mysql.com

the compilation seems to went fine and no error but i cant seems to run the test to test whether my installation running or not.
i've tried to run the run-all-tests using this command and got the following error

[root@localhost sql-bench]# perl run-all-tests
Can't locate DBI.pm in @INC (@INC contains: /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 .) at run-all-tests line 36.
BEGIN failed--compilation aborted at run-all-tests line 36.
[root@localhost sql-bench]#

whats wrong?
what shall i do to fix this problem.

i have compiled httpd and php successfully and they run fine.
under php compilation i use this command:

./configure --with-apxs2=/usr/local/apache2/bin/apxs --with-mysql

how do i direct php to use my newly installed MySQL which is installed at /usr/local/mysql?

i dont install webserver rpm from my redhat9 disk.

OK now that i have fix the line 36 problem by going into Redhat 9 disk to and install an rpm
perl-DBD-MySQL-XX-XX.rpm but encounter another new problem when running run-all-tests

[root@localhost sql-bench]# perl run-all-tests
install_driver(mysql) failed: Can't load '/usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.10: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.0/i386-linux-thread-multi/DynaLoader.pm line 229.
at (eval 51) line 3
Compilation failed in require at (eval 51) line 3.
Perhaps a required shared library or dll isn't installed where expected
at /usr/local/mysql-standard-4.0.18-pc-linux-i686/sql-bench/server-cfg line 240

Smells like it's asking for perl - did you build --with-perl? and do you have perl in that path?

nop, i dont notice that i have --with-perl when building httpd and php.
so how to fix this?
if i need to build with perl, how am i gonna do it?
should i uninstall 1st then rebuild or just build over existing one?

Hmm. did you use the --with-perl when building your mysql from source?

nop,
i follow what the INSTALL-BINARY told me to do inorder to install.
see below on what i do to install:-

The basic commands you must execute to install and use a MySQL binary
distribution are:

shell> groupadd mysql
shell> useradd -g mysql mysql
shell> cd /usr/local
shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf -
shell> ln -s full-path-to-mysql-VERSION-OS mysql
shell> cd mysql
shell> scripts/mysql_install_db
shell> chown -R root .
shell> chown -R mysql data
shell> chgrp -R mysql .
shell> bin/mysqld_safe --user=mysql &

For versions of MySQL older than 4.0, substitute `bin/safe_mysqld' for
`bin/mysqld_safe' in the final command.