GK SCIENTIST

General Knowledge One Stop Source
Menu
  • Home
  • Social Science
    • History
    • Political Science
    • Geography
  • Science
    • Physics
    • Chemistry
    • Biology
  • Chemistry Notes
  • Mathematics
  • Computer
  • Tutorial MySQL
  • Tutorial Python
  • Java Tutorial
  • English Grammar
  • English Essay
  • Indian Anthropology
  • Philosophy
  • Solved Paper
  • UPSC
  • Current Content
    • Current Affairs
    • RSTV News
    • Yojana and Kurukshetra Gist
  • Donate
  • Contact Us

If you are interested in advertising to our audience, submit the advertising enquiry form.

Advertising Enquiry
Computer

Create MySQL Database and Connection in Python

Gk Scientist December 11, 2022 No Comments
Tweet WhatsApp Telegram

Create MySQL Database and Connection in Python:

In the previous blog, we learn about how to install pymysql and Xampp. Both functionalities are required to create MySQL database and connection in Python.

(1) Open the Xampp control panel and press the Apache and MySQL start button as shown below.

xampp - Create MySQL Database and Connection in Python
xampp conrtol panel - Create MySQL Database and Connection in Python

(2) If Apache and MySQL are highlighted in green color it means they start working as shown below.

apache and mysql start 1 - Create MySQL Database and Connection in Python

(3) Now open your browser and type “http://localhost/phpmyadmin/“. The below interface is getting opened as shown below.

phypmyadmin localhost open - Create MySQL Database and Connection in Python
We can use the PyCharm code editor for this example. If you do not know about it then follow this link- How to install PyCharm for Python and create a program in it.

(4) Open PyCharm code editor, create a new Python file in it, and import library pymysql. For creating a connection pass three parameters i.e. hostname, user name, and password. After that write a query for creating a database as shown below. (For example, we create a database named Employee).

database created in mysql through python - Create MySQL Database and Connection in Python

(5) Now open localhost/phpmyadmin in the browser and you see that the Employee database is created as shown below.

database created in xampp - Create MySQL Database and Connection in Python

Tutorial Python
Tutorial MySQL
Object-Oriented Programming (OOP)
Procedure-Oriented Programming

Email (Electronic Mail)
Database Models or Data Models

Information Security in E-Commerce

Python (programming language)– Wikipedia
Prev Article
Next Article

Related Articles

Inheritance in Java
Inheritance in Java: We can use the Eclipse IDE for …
Gk Scientist January 10, 2023 Computer

Inheritance in Java

Create Table in MySQL
Create Table in MySQL: (1) In the previous blog we …
Gk Scientist November 10, 2022 Computer

Create Table in MySQL

Python MySQL Equi Join
Python MySQL Equi Join: (1) Equi Join may be defined …
Gk Scientist December 14, 2022 Computer

Python MySQL Equi Join

Python SQLite Search Query
Python SQLite Search Query: We can use the PyCharm code …
Gk Scientist December 9, 2022 Computer

Python SQLite Search Query

Simple Java GUI (Graphical User Interface)
Simple Java GUI: We can use the Eclipse IDE for …
Gk Scientist December 30, 2022 Computer

Simple Java GUI (Graphical User Interface)

Create JSON File in Python
Create JSON File in Python: We can use the PyCharm …
Gk Scientist December 4, 2022 Computer

Create JSON File in Python

MySQL Cross Join
MySQL Cross Join: The CROSS JOIN clause returns the Cartesian …
Gk Scientist November 17, 2022 Computer

MySQL Cross Join

Python MySQL Between Operator
Python MySQL Between Operator: (1) MySQL Between Operator is a …
Gk Scientist December 16, 2022 Computer

Python MySQL Between Operator

Leave a Reply Cancel Reply

Search




  • Popular
  • Recent




GK SCIENTIST

General Knowledge One Stop Source

Information

  • About Us
  • Terms and Condition, Disclaimer
  • Contact Us

Android Apps

  • IAS App For English Medium Students
  • IAS Basics App For English Medium Students
  • IAS Hindi App For Hindi Medium Students
DMCA.com Protection Status

Popular Tags

Biology (33) Biology Questions (88) Chemistry (57) Computer (212) Current Affairs (4) Current Content (0) Economy (10) English Essay (172) English Grammar (75) English Literature (10) Geography (83) History (259) Indian Anthropology (11) Indian Polity (14) JKAS Mains Question Papers (17) Mathematics (68) Moral Science (7) NCERT & Other Boards Books (25) Philosophy (114) Physics (89) Political Science (132) RS TV News (33) Science (553) Social Anthropology (7) Social Science (17) Solved Paper (47) UPSC (7) UPSC Mains Question Papers (26)

Downloads

  • NCERT Books
  • Old NCERT Books
  • NIOS Books For IAS, SSC, and State PSC Exam
  • Tamil Nadu Board Books: Important For UPSC, SSC, and State PSC Exam
  • Modern Indian and World History Notes For IAS Exam
  • UPSC Topper 2013 Gaurav Agrawal Notes For IAS Preparation
  • UPSC IAS Prelims General Studies – Previous Year Papers
  • UPSC Mains Question Papers

Copyright © 2023 GK SCIENTIST
Theme by MyThemeShop.com& Hosted On Cloudways

Ad Blocker Detected

Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

Refresh
 

Loading Comments...