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.
Asked
Active
Viewed 3,178 times
-1
-
use `pymysql` or multitude of other sql modules. – Rocky Li Oct 30 '18 at 14:17
-
Duplicate? https://stackoverflow.com/q/372885/5520354 – C14L Oct 30 '18 at 14:18
-
From C14L's link, I recommend: https://stackoverflow.com/a/51626041/3271649 – Ctrl S Oct 30 '18 at 14:20
-
Possible duplicate of [How do I connect to a MySQL Database in Python?](https://stackoverflow.com/questions/372885/how-do-i-connect-to-a-mysql-database-in-python) – Anthony Geoghegan Oct 30 '18 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 Oct 30 '18 at 15:09
-
[Solution](https://stackoverflow.com/a/75639931/6013016) – Scott Mar 05 '23 at 02:49
1 Answers
0
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.
TeilaRei
- 577
- 1
- 6
- 22