connect access denied in perl

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 only when

connect access denied in perl DBI

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

Re: connect access denied in perl DBI

$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 owned by