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:          
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
再次執行測試指令碼，驗證成功