List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 1 2003 12:12am
Subject:Re: Can't load data infile ...says :" ...(Using password: YES)"
View as plain text  
At 18:49 -0500 2/28/03, Cl. Yuri Huitron Alvarado wrote:
>Hi, I have MySQL  3.23.49   and I access the mysql with :
>% mysql -u user -p
>Enter password:*******
>
>and type :
>mysql> use user's_database;
>
>and returns :
>Reading table information for completion of table and column names
>You can turn off this feature to get a quicker startup with -A
>
>Database changed
>
>but when I type :
>load data infile '/user's_path/datafile' into table database's_table fields
>terminated by ',' (field_1,field_2,field_3,field_4);
>
>I returns:
>ERROR 1045: Access denied for user: 'user@localhost' (Using password: YES)
>
>
>What can be happening ?

You probably don't have the FILE privilege, or the file named in the
statement doesn't exist on the server host, or the server can't
access it.

Thread
what is the best way to check if primary key exists?Jianping Zhu20 Feb
  • Re: what is the best way to check if primary key exists?1LT John W. Holmes20 Feb
    • where shoud i put sql scriptJianping Zhu27 Feb
      • is there a better way to store comments in mysql table?Jianping Zhu27 Feb
  • Re: what is the best way to check if primary key exists?Roger Baklund20 Feb
Re: where shoud i put sql scriptPaul DuBois27 Feb
  • mysql encripted password from perlJianping Zhu28 Feb
    • Re: mysql encripted password from perlJianping Zhu28 Feb
      • Re: mysql encripted password from perlJeff Kilbride1 Mar
        • Can't load data infile ...says :" ...(Using password: YES)"Cl. Yuri Huitron Alvarado1 Mar
          • Re: Can't load data infile ...says :" ...(Using password: YES)"Paul DuBois1 Mar
    • Re: mysql encripted password from perlKH Chiu1 Mar
      • List commandsLda Dominio2 Mar
        • RE: mysql not replicatingDan Rossi2 Mar
Re: is there a better way to store comments in mysql table?Paul DuBois27 Feb
  • Re: is there a better way to store comments in mysql table?Jianping Zhu27 Feb
  • Re: is there a better way to store comments in mysql table?Paul DuBois27 Feb
Re: is there a better way to store comments in mysql table?Paul DuBois27 Feb