Step 1 – Install MYSQL Server
- https://www.devopsschool.com/blog/how-to-download-and-install-mysql-in-macos-10/
- https://www.devopsschool.com/tutorial/mysql/how-to-install-mysql-on-centos-7.html
Step 2 – Install python mysql connector using PIP3
$ sudo pip3 install mysql-connector-python
Step 3 – Using Python – Check a mysql Connection
Step 4 – Using Python – Create a database
Step 5 – Using Python – Create a Table
Step 6 – Using Python – Insert Row Ops
Step 7 – Using Python – Read Row Ops
Step 8 – Using Python – Update Row Ops
Step 9 – Using Python – Delete Row Ops
I’m a DevOps/SRE/DevSecOps/Cloud Expert passionate about sharing knowledge and experiences. I have worked at Cotocus. I share tech blog at DevOps School, travel stories at Holiday Landmark, stock market tips at Stocks Mantra, health and fitness guidance at My Medic Plus, product reviews at TrueReviewNow , and SEO strategies at Wizbrand.
Do you want to learn Quantum Computing?
Please find my social handles as below;
Rajesh Kumar Personal Website
Rajesh Kumar at YOUTUBE
Rajesh Kumar at INSTAGRAM
Rajesh Kumar at X
Rajesh Kumar at FACEBOOK
Rajesh Kumar at LINKEDIN
Rajesh Kumar at WIZBRAND
Find Trusted Cardiac Hospitals
Compare heart hospitals by city and services — all in one place.
Explore Hospitals
Good coverage of basic Python–MySQL operations, but one real-world gap is production-grade database handling. In actual systems, direct raw queries with basic connectors can quickly become risky without connection pooling, retry logic, and proper transaction management. Also, error handling and rollback strategies are critical—especially when multiple writes are involved, otherwise partial failures can corrupt business data. In CI/CD-driven environments, teams usually abstract DB access through ORM layers or service APIs instead of tightly coupling scripts directly to MySQL connections.