Python Tutorials: Database operations using python – mysql

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

• Author
• Recent Posts

Follow me

Rajesh Kumar

Mentor for DevOps - DevSecOps - SRE - Cloud - Container & Micorservices at Software AG

Join my following certification courses...
- DevOps Certified Professionals (DCP)
- Site Reliability Engineering Certified Professionals (SRECP)
- Master in DevOps Engineering (MDE)
- DevSecOps Certified Professionals (DSOCP)
URL - https://www.devopsschool.com/certification/

My Linkedin - https://www.linkedin.com/in/rajeshkumarin

Follow me

Latest posts by Rajesh Kumar (see all)

• What is Mobile Virtual Network Operator? - April 18, 2024
• What is Solr? - April 17, 2024
• Difference between UBUNTU and UBUNTU PRO - April 17, 2024