My uneducated guess is that "local" may be different using the DBI module than when
starting mysql from the shell. Perhaps using the full path might help.
>Hi everyone. I read in tab separated data using LOAD DATA LOCAL INFILE
>using the mysql command line (freebsd) client often. It works great.
>Recently I created a perl/dbi script that automates this for me, mostly so
>I didn't have to type it in each time. The same query used in DBI that I
>use in mysql is giving me an access error! Here's what I do...
>
>$db = DBI->connect("DBI:mysql:$database:$hostname", $username, $password);
>
># now add the new dat
>$query = $db->prepare("LOAD DATA LOCAL INFILE 'tempo' INTO TABLE master");
>$query->execute;
>$query->finish;
>
>Do you know what could be up? It's the exact same syntax that works fine
>in the command line, so it can't be an access thing. The error I get is
>
>Access denied for user: 'user@stripped' (Using password: YES) at
>./unmac.pl line 37, <> chunk 1. { line 37 is query->execute }
>
>
>
>
>--
>Brian Whitman
>bwhitman@stripped
>Crudites Sound Ventures
>
>
>
>--
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/php/manual.php" before
>posting. To request this thread, e-mail mysql-thread46482@stripped
>
>To unsubscribe, send a message to:
> <mysql-unsubscribe-cj=interlog.com@stripped>
>
>If you have a broken mail client that cannot send a message to the above
> address(Microsoft Outlook), you can use http://lists.mysql.com/php/unsubscribe.php
Christopher R. Jones, P.Eng.
14 Oneida Avenue
Toronto, Ontario M5J 2E3
Tel. 416 203-7465
Fax. 416 203-3044
Email cj@stripped
