SQLAlchemy no password supplied error

Question

This is probably a silly error but I cannot seem to find a satisfying solution.

When running db.create_all(), I got the following error.

sqlalchemy.exc.OperationalError: (OperationalError) fe_sendauth: no password supplied  None None 

My database link is set as

'postgresql://localhost/db_name' 

This worked fine on my Mac and Heroku, but is not OK on ubuntu (digitalocean).

Any ideas what I might be doing wrong?

Answer 1

You probably just need to remove "localhost" from your connection string:

'postgresql:///db_name' 

That tells psycopg2 to use Unix-domain sockets. Your default configuration will use "ident" so you'll be connecting as the user that runs the script. In the default configuration, "md5" only applies to TCP connections.

Answer 2

URL pattern should be:

postgresql://user:password@localhost:5432/database_name 

pip install psycopg2
the user should be postgres or any other user you have created and intend to use

similarly for mySql it would be:

mysql://user:pass@localhost:3306/database_name 

pip install mysql-python