title: Postgres 14.3 created user authentication failed
body: <p>I am new to this SQL stuff and I recently installed Postgres 14.3 on my windows machine as part of an online learning requirement. I created a database and a user to connect to the database in the following lines from the shell:</p>
  <pre class="lang-none prettyprint-override"><code>postgres=# create database staff;
  postgres=# create user Naruto with encrypted password 'secret';
  postgres=# grant all privileges on database staff to Naruto;
  postgres=# \c staff Naruto;
  
  password for user Naruto:
  </code></pre>
  <p>After inputting the password I get an error message like this</p>
  <blockquote>
  <p>connection to server at &quot;local host&quot; (127.0.0.1), port 5432 failed: FATAL: password authentication failed for user &quot;Naruto&quot;
  Previous connection kept</p>
  </blockquote>
  <p>Whereas the video description from which I am taking tutorials didn't ask for a password prompt but it connected to the database straight up with the designated user.</p>
  <p>I have tried numerous suggestions on stack overflow but still, no breakthrough in any way. I'd appreciate any hint because I haven't recorded any progress with my learning recently. Thanks!</p>