linux安装mysql dbi

安装perl mysql dbi

最快捷的方式是通过cpan安装了
CPAN
install DBI
install DBD::mysql
即可，但是由于环境设置的问题，到时自动安装失败，于是采用手工编译
首先下载DBD安装包，也可以通过cpan下载
cpan
get DBD::mysql
进入到下载解压目录
我们的mysql版本为5.1.51,需要
[root@tjdb02 oracle]#  rpm -qa | grep -i mysql
MySQL-client-5.1.51-1.glibc23
MySQL-devel-5.1.51-1.glibc23--需要安装MySQL-devel-5.1.51-1.glibc23.x86_64.rpm
MySQL-server-5.1.51-1.glibc23
依次执行
perl Makefile.PL
make
make test
make 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:           root@localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         5.1.51-log MySQL Community Server (GPL)
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    latin1
Conn.  characterset:    latin1
UNIX socket:            /data/mysql/mysql.sock
Uptime:                 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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15480802/viewspace-692504/