Breaking News: Grepper is joining You.com. Read the official announcement!

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

Nice Narwhal answered on December 6, 2022 Popularity 2/10 Helpfulness 3/10

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

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

Comment

# 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: using whatever

Link to this answer
Share Copy Link

Contributed on Dec 06 2022

Nice Narwhal

0 Answers Avg Quality 2/10

Closely Related Answers

(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

# 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

Link to this answer
Share Copy Link

Contributed on Apr 30 2023

sandy_inspires

0 Answers Avg Quality 2/10

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

Contents

More Related Answers

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

Closely Related Answers

(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)

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.