Unable to construct the sql url as the password is having special characters.

User16753724663 — Fri, 21 Mar 2025 12:48:19 GMT

while using the sqlalchemy, unable to connect with sql server from databricks:

user='user@host.mysql.database.azure.com'
password='P@test'
host="host.mysql.database.azure.com"
database = "db"
connect_args={'ssl':{'fake_flag_to_enable_tls': True}}
connect_string = 'mysql+pymysql://{}:{}@{}/{}'.format(user,password,host,database)
     
engine = create_engine(connect_string, connect_args=connect_args, echo=False)
map = pd.read_sql("SELECT * FROM rig_emissions.tag_lookup", engine)
map['key'] = map['rig'].astype(str)+map['tagpath']
 
mapDict = dict(zip(map.key,map.id))

It returns the below error:

(pymysql.err.OperationalError) (2003, 'Can't connect to MySQL server on 'P@test' ([Errno -2] Name or service not known)')

Re: Unable to construct the sql url as the password is having special characters.

User16753724663 — Wed, 16 Jun 2021 16:06:22 GMT

We can use urllib.parse to handle special characters. Here is an example:

import urllib.parse
user='user@host.mysql.database.azure.com'
 
password=urllib.parse.quote_plus("P@test")
host="host.mysql.database.azure.com"
database = "db"
 
connect_args={'ssl':{'fake_flag_to_enable_tls': True}}
 
connect_string = 'mysql+pymysql://{}:{}@{}/{}'.format(user,password,host,database)
 
 
engine = create_engine(connect_string, connect_args=connect_args, echo=False)

topic Re: Unable to construct the sql url as the password is having special characters. in Warehousing & Analytics

Unable to construct the sql url as the password is having special characters.

Re: Unable to construct the sql url as the password is having special characters.