mysql connection

$dsn = "DBI:mysql:test;mysql_read_default_file=/home/joe/my.cnf";
$dbh = DBI->connect($dsn, $user, $password)

# file my.cnf

[client]
host = 192.168.2.123
port = 3306

database = server
user = root
#password = your_password

default-character-set = utf8