mysql50521_解决./run-all-tests问题（mysql-5.0.22）

最近装snort总出现一些问题，在装完mysql-5.0.22后想要运行测试一下，出现了一大堆错误。下面就把几天的心得写下，供碰到问题的朋友参考。

错误问题：

1.安装了mysql后，运行./run-all-tests时出现：

install_driver(mysql) failed: Can't locate DBD/mysql.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 (eval 51) line 3.

Perhaps the DBD::mysql perl module hasn't been fully installed,

or perhaps the capitalisation of 'mysql' isn't right.

Available drivers: ExampleP, Pg, Proxy.

at /usr/local/mysql/sql-bench/server-cfg line 247

2.于是就安装DBD-mysql-4.013.tar.gz，安装后再运行出现：

/usr/bin/perl: relocation error: /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBD/mysql/mysql.so: undefined symbol: DBIc_TRACE_LEVEL

解决：

1.mysql-5.0.22的安装:

shell> groupadd mysql

shell> useradd -g mysql mysql

shell> tar -zxvf mysql-5.0.22.tar.gz

shell> cd mysql-5.0.22

shell> ./configure --prefix=/usr/local/mysql

shell> make

shell> make install

shell> cp support-files/my-medium.cnf /etc/my.cnf

shell> cd /usr/local/mysql

shell> bin/mysql_install_db --user=mysql

shell> chown -R root  .

shell> chown -R mysql var

shell> chgrp -R mysql .

shell> bin/mysqld_safe --user=mysql &

2.DBD-mysql-3.0008.tar.gz的安装：

shell> tar -zxvf DBD-mysql-3.0008.tar.gz

shell> cd DBD-mysql-3.0008

shell> export LANG=C

shell> perl Makefile.PL \

--libs="-L/usr/local/mysql/lib/mysql -lmysqlclient -lz" \

--cflags=-I/usr/local/mysql/include/mysql \

--testhost=127.0.0.1 \

--mysql_config=/usr/local/mysql/bin/mysql_config

shell> make

shell> make install

注：安装DBD-mysql-4.013.tar.gz后出现问题属于版本问题，改用DBD-mysql-3.0008.tar.gz后就可以正常运行mysql的./run-all-tests --user=root --password=******。