checking which mysql dbd is installed on linux

Shell Programming and Scripting
1

Hi,

I am new to linux, and i want to know which mysql dbd is installed on linux,

what is the command to check this.

bash-2.05$ uname -a
Linux SURINT01 2.4.7-10 #1 Thu Sep 6 17:27:27 EDT 2001 i686 unknown

Thanks

Prakash GR

2 
mysql -version
3

Hi neo,

thx for reply i am not looking for mysql version but i am looking mysql dbd(database driver) installed on linux server, how to check what version of DBD is installed.

thanks

Prakash

4

Do you mean the PERL DBD for MySQL?

5

Hi,

ys right i need to know mysql dbd version installed in that server.

thanks

Prakash GR

6

Hi,

The DBI->available_drivers() method shows all available drivers in your system. The script is present in Tim Bunce's classic book on Perl DBI.

$
$ cat connect_test.pl
#!/usr/bin/perl -w
# connect_test.pl
# Chapter 2
# Listing 1

use strict;
use DBI;

print "Available database drivers:\n";
print "*" x 40, "\n";
print join("\n", DBI->available_drivers()), "\n\n";

$
$ perl connect_test.pl
Available database drivers:
****************************************
CSV
DBM
ExampleP
File
Gofer
Oracle
Proxy
Sponge
mysql

$

I have mysql and Oracle drivers in my system, for example.

Hope that helps,
tyler_durden

7 
perl -MDBD::mysql -e 'print $DBD::mysql::VERSION'