I doubt mysql as access to /home/M8ram/testmysql/pet.txt. Mertens Bram wrote:
>On Wed, 2002-08-28 at 16:51, Egor Egorov wrote: > >>Put into my.cnf file : >>[mysql] >>local-infile=1 >> >>or start mysql client with --local-infile=1 option. >> > >I tried the first option and it works when use the following command to >load the data-file: >mysql> LOAD DATA LOCAL INFILE '/home/M8ram/testmysql/pet.txt' INTO TABLE >pet; >Query OK, 3 rows affected (0.19 sec) >Records: 3 Deleted: 0 Skipped: 0 Warnings: 0 > >But when I use the above command without the LOCAL option it displays >the following error: >mysql> LOAD DATA INFILE '/home/M8ram/testmysql/pet.txt' INTO TABLE pet; >ERROR 1045: Access denied for user: 'M8ram@localhost' (Using password: >NO) > >Is this 'normal behaviour'? > > >About the second suggestion: where should this file be located? Is it >possible that it does not exist yet? If so can I create a file named >"my.cnf" with a text-editor (like KWrite) and put it in my home >directory? > > >Thanks for the help! > --------------------------------------------------------------------- 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
