Is there a way to connect to the online mysql database using Python

Question

I want to connect my Python 3 script to my online database so that i can fetch and make changes to the data on the online database. I am a bit new to Python.

From C14L's link, I recommend: stackoverflow.com/a/51626041/3271649 — Ctrl S
– Ctrl S, Commented Oct 30, 2018 at 14:20
Possible duplicate of How do I connect to a MySQL Database in Python? — Anthony Geoghegan
– Anthony Geoghegan, Commented Oct 30, 2018 at 14:40
Pymysql throws an error " pymysql.err.OperationalError: (1045, "Access denied for user 'uxxxxxxx'@'49.249.xxx.xxx' (using password: YES)") " — Ayush Singh
– Ayush Singh, Commented Oct 30, 2018 at 15:09

TeilaRei · Accepted Answer · 2018-10-30 14:24:05Z

1

You can find one possible way here, Database Programming in Python at OpenSource. Another one is here, Python Connecting to MySQL Databases at mySQL Tutorial.

And you can try this, script by kirang89 on GitHub.

Welcome to the community. If you give us your code where you attempted to do this with a specific issue you are trying to solve, you will get a much better guidance and solution. Ina meanwhile, try to find a similar already answered question.

answered Oct 30, 2018 at 14:24

TeilaRei

5872 gold badges7 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Scott Over a year ago

Solution

Collectives™ on Stack Overflow

Is there a way to connect to the online mysql database using Python

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related