Password with @ can't connect the database

Question

When I tried to connect database from Python, my password contains special character say for example: 123@789. My Connection fails because of this.

I make connection to the database as follows:

engine = sqlalchemy.create_engine('sybase+pyodbc://user:123@789@Database')

Hey @JohnGordon just curious, But does that @ / special character really matter? Do you think that would cause a problem ? — Mahesh Kumaran, Nov 01 '19 at 15:21
Changing your password just to conform to a specific interface is the wrong approach. You *can* specify whatever password you have if you use the interface properly. — chepner, Nov 01 '19 at 15:23
@MaheshKumaran `@` is used to separate the password from the username in the connect string, so yes it is a problem. — John Gordon, Nov 01 '19 at 15:53

score 6 · Answer 1 · answered Nov 01 '19 at 15:19

URL-encode the @ in the password. Adapted from https://docs.sqlalchemy.org/en/13/core/engines.html,

import urllib.parse
password = urllib.parse.quote_plus("123@789")  # '123%40456'
engine = sqlalchemy.create_engine(f'sybase+pyodbc://user:{password}@Database')

Alternatively, let sqlalchemy generate the URL for you using sqlalchemy.engine.url.URL.

Password with @ can't connect the database

1 Answers1