title: How to store password in password file sqoop
body: <p>I want to store the password into a file &amp; later use the same in sqoop command.</p>
  
  <p>According to sqoop documentation <code>--password-file</code> option allow us for storing password. so i am storing it in pwd file with password abc text only. &amp; hits the below command.</p>
  
  <pre><code>sqoop import --connect jdbc:mysql://localhost:3306/db --username bhavesh --password-file /pwd --table t1 --target-dir '/erp/test' 
  </code></pre>
  
  <p>assuming pwd file is stored over HDFS</p>
  
  <p>as a result i am getting following error : </p>
  
  <pre><code>java.sql.SQLException: Access denied for user 'bhavesh'@'localhost' (using password: YES)
  </code></pre>
  
  <p>When I perform the same operation using -p option it works fine for me. </p>