CREATE DATABASE myProject;
CREATE USER myUser WITH PASSWORD '1234';

#connect through python
import psycopg2
psycopg2.connect("dbname=myProject user=myUser host=localhost password=1234 port=5432")

Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/data/project/venv/lib/python3.6/site-packages/psycopg2/__init__.py", line 130, in connect
    conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
psycopg2.OperationalError: FATAL:  password authentication failed for user "myUser"
FATAL:  password authentication failed for user "myUser"