mysqlreport 安装

最新推荐文章于 2022-06-08 20:00:49 发布

原创最新推荐文章于 2022-06-08 20:00:49 发布 · 678 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#perl #compilation #mysql #library #file #object

本文介绍在Linux环境下安装MySQL数据库及多个Perl模块的过程，包括DBI、Data-ShowTable、DBD-mysql等，并解决安装过程中遇到的常见问题。

一般linux安装的时候默认安装了perl。

perl -v 验证下

1.安装mysql

3.DBI安装

到http://search.cpan.org/查找相应的包

#tar zxf DBI-1.58.tar.gz #cd DBI-1.58 #perl Makefile.pl #make #make test #make #make install

4.data-showtable包

到http://search.cpan.org/查找相应的包

tar xvf Data-ShowTable.tar.gz cd Data-ShowTable-?.?? perl Makefile.PL make make test make install

5.msql-mysql-modules

上http://search.cpan.org/ 找

tar zxvf Msql-Mysql-modules-.tar.gz cd Msql-Mysql-modules-?.?? perl Makefile.PL make make test make install

6.DBD-mysql
安装DBD: DBD-mysql-4.005

#perl Makefile.PL --mysql_config=/usr/local/mysql/bin/mysql_config --with-mysql=/usr/local/mysql --testuser=root #make #make test #make #make install

7.mysqlreport 安装

tar zxvf mysqlreport.tar.gz

执行 ./mysqlreport

如果报错

install_driver(mysql) failed: Can't load '/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.12: cannot open shared object file: No such file or directory at /usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230. at (eval 6) line 3 Compilation failed in require at (eval 6) line 3. Perhaps a required shared library or dll isn't installed where expected at /root/mysqlreport line 162

则将mysql

cp /usr/local/mysql/lib/mysql/libmysqlclient.so.15 /usr/lib/