Please include your code and the output you're getting. Take a look at: How do I post a question effectively?

Hi,

I create a new database in MySQL and connecting it using Perl.But i am getting "unable to connect database" error. If i connect the default database available in the MySQL(default during the installation) then the program working fine. Can any one help me regarding this.

#!/usr/local/bin/perl
 use DBI;
 $dbh = DBI->connect('dbi:mysql:ram','root','root')
 or die "Connection Error: $DBI::errstr\n";
 $sql = "select * from test1";
 $sth = $dbh->prepare($sql);
 $sth->execute
 or die "SQL Error: $DBI::errstr\n";
 while (@row = $sth->fetchrow_array) {
 print "@row\n";
 }
[download]

error: DBI connect('ram','root',...) failed: Unknown database 'ram' at C:\Documents and Settings\Admin\Desktop\test.pl line 3 Connection Error: Unknown database 'ram'

Thanks in advance

Ram

Is your database sever on the localhost and running on the default port?

What arguments to mysql are you using to connect on the command line?

You might want look at something like:

my $db = 'ram';
my $host = ''; # hostname
my $port = ''; # portnumber
$dbh = DBI->connect("DBI:mysql:database=$db;host=$host;port=$port",'ro
+ot','root') or die "Connection Error: $DBI::errstr\n";
[download]

It is the answer from your DB server; I can translate it into many languages, if you didn't understood it.

I attached my sql logs here

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| ram                |
| test               |
+--------------------+
4 rows in set (0.14 sec)
[download]