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!
>
