(pymysql.err.OperationalError) (3159, 'Connections using insecure transport are prohibited while --require_secure_transport=ON.') (Background on this error at: https://sqlalche.me/e/20/e3q8)

(pymysql.err.OperationalError) (3159, 'Connections using insecure transport are prohibited while --require_secure_transport=ON.') (Background on this error at: https://sqlalche.me/e/20/e3q8)

Comment

0

# add connection args - this is a temp fix - don't use in production connect_args={'ssl':{'fake_flag_to_enable_tls': True}} connect_string = 'mysql+pymysql://{}:{}@{}/{}'.format(user,pw,host,database) connector = create_engine(connect_string,connect_args=connect_args) df = pd.read_csv('iris.data') df.to_sql('iris',connector,if_exists='replace',index_label='id')

Popularity 1/10 Helpfulness 1/10 Language python

Source: stackoverflow.com

Tags: python this using

Share

Link to this answer
Share Copy Link

Contributed on Apr 30 2023

sandy_inspires

0 Answers  Avg Quality 2/10

---

Closely Related Answers

pymysql.err.OperationalError: (3159, 'Connections using insecure transport are prohibited while --require_secure_transport=ON.')

Comment

0

# tricks pymysql no errors again connection = pymysql.connect(host=host, user=user, password=password, db=db, cursorclass=pymysql.cursors.DictCursor, ssl={"fake_flag_to_enable_tls":True})

Popularity 2/10 Helpfulness 3/10 Language whatever

Source: stackoverflow.com

Tags: whatever using

Share

Link to this answer
Share Copy Link

Contributed on Dec 06 2022

Nice Narwhal

0 Answers  Avg Quality 2/10

---