Re: connect access denied in perl DBI

2001-05-09 Thread Colin Faber
$dbh = DBI->connect($dsn, $user_name, $password, {RaiseError => 1}) || die ("Unable to establish connection to mysqld: " . $DBI::errstr); tang jie wrote: > > the user "mysql" is given all priviliges, > another user is given db table privileges (INSERT, > SELECT, etc.), > the database files are

connect access denied in perl DBI

2001-05-09 Thread tang jie
the user "mysql" is given all priviliges, another user is given db table privileges (INSERT, SELECT, etc.), the database files are owned by user "mysql", in the same perl DBI script, at the very biginning, the line: $dbh = DBI->connect($dsn, $user_name, $password, {RaiseError => 1}); works when