安装perl mysql dbi

最快捷的方式是通过cpan安装了

CPANinstall DBIinstall DBD::mysql即可，但是由于环境设置的问题，到时自动安装失败，于是采用手工编译首先下载DBD安装包，也可以通过cpan下载cpanget DBD::mysql进入到下载解压目录我们的mysql版本为5.1.51,需要[root@tjdb02 oracle]#  rpm -qa | grep -i mysqlMySQL-client-5.1.51-1.glibc23MySQL-devel-5.1.51-1.glibc23--需要安装MySQL-devel-5.1.51-1.glibc23.x86_64.rpmMySQL-server-5.1.51-1.glibc23依次执行perl Makefile.PLmakemake testmake install然后执行测试脚本，报告DBI connect('database=mysql;host=localhost','ywdbadm',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at testmysqldbi.pl line 7登录mysql，查询得到如下信息

mysql> \s;

--------------mysql  Ver 14.14 Distrib 5.1.51, for unknown-linux-gnu (x86_64) using readline 5.1

Connection id:          12514

Current database:Current user:           SSL:                    Not in useCurrent pager:          stdoutUsing outfile:          ''Using delimiter:        ;Server version:         5.1.51-log MySQL Community Server (GPL)Protocol version:       10Connection:             Localhost via UNIX socketServer characterset:    latin1Db     characterset:    latin1Client characterset:    latin1Conn.  characterset:    latin1UNIX socket:            /data/mysql/mysql.sockUptime:                 18 days 14 hours 49 min 12 sec

Threads: 26  Questions: 23083745  Slow queries: 7  Opens: 1330  Flush tables: 1  Open tables: 64  Queries per second avg: 14.350

--------------

ERROR:

No query specified接着查找mysql_config文件[root@tjdb02 bin]# find -name mysql_config -print | xargs grep "socket"socket='/var/lib/mysql/mysql.sock'        --socket         [$socket]        --socket)  echo "$socket" ;;#echo "socket: '"$socket"可以发现两个记录的socket的信息不一致，则接着执行ln -s  /data/mysql/mysql.sock  /var/lib/mysql/mysql.sock再次执行测试脚本，验证成功

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15480802/viewspace-692504/，如需转载，请注明出处，否则将追究法律责任。