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 $user_name = "mysql", 

the other user is denied access to the database.

does anyone know why?

Thanks!

 

__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to