title: FATAL: password authentication failed for user postgres aurora
body: <p>If I create a user logged in as postgres to the root db and create a user... it doesn't work. What am I doing wrong?</p>
  <pre><code>postgres=&gt; CREATE ROLE myUser WITH LOGIN PASSWORD 'xxx';
  CREATE ROLE
  postgres=&gt; GRANT CONNECT ON DATABASE myDatabase TO myUser;
  GRANT
  postgres=&gt; GRANT USAGE ON SCHEMA public to myUser;
  GRANT
  postgres=&gt; GRANT SELECT  ON ALL TABLES IN SCHEMA public TO myUser;
  GRANT
  </code></pre>
  <p>When I go to authenticate I get an error.
  psql -h $dbURL -U myUser myDatabase</p>
  <p>FATAL:  password authentication failed for user myUser</p>