Hi

I have written a script to connect to database using mysql and get the table. I am pasting the script here. But its giving me an error that Access Denied, though if I log in to mysql using same user , i m able to log in. But not using script.

The script is

#!/usr/bin/perl

use DBI;
$dbh = DBI->connect('dbi:mysql:mysql','root','redhat') or die "Connection Error: $DBI::errstr \n";
$sql="select * from SUNNY";
$sth=$dbh->prepare($sql);
$sth->execute or die " SQL Error: $DBI::errstr\n";
while (@row = $sth->fetchrow_array){
print "@row\n";
}

its giving an error that ...

DBI connect('mysql','root',...) failed: Access denied for user 'root'@'localhost' (using password: YES) at ./test line 5
Connection Error: Access denied for user 'root'@'localhost' (using password: YES)

if I log in directly , I m able to log in and even have full grants.

mysql> show GRANTS;
+---------------------------------------------------------------------+
| Grants for root@localhost |
+---------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION |
+---------------------------------------------------------------------+
1 row in set (0.00 sec)


guys do help me out ......

Please use CODE tags in the future..makes things easier to read. And if that's the EXACT code you're using above, the problem is pretty clear. I'd suggest you reference the docs on the Perl:BI module. You're not calling it correctly...try this:
You missed the DBI being upper-case (things are case sensitive), and specified your database name as 'mysql', which is reserved.

I corrected the script as below ..but still same error.

$dbh = DBI->connect('DBI:mysql:MANMEET','root','redhat') or die "Connection Error: $DBI::errstr \n";

Ok...does the root user actually HAVE a password set, because by default the MySQL root user doesn't. And where is the RaisError string in your corrected version? Have you tried a different MySQL user ID?

Moved: This thread is more suitable in <PROGRAMMING> and has been moved accordingly to help your thread/question get the exposure it deserves.