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

Python MySQL (pymysql and Xampp Installation)

Gk Scientist December 11, 2022 No Comments
Tweet WhatsApp Telegram

Python MySQL:

(1) MySQL is a fast, open-source, and easy-to-use relational or tabular database. It is suitable for small and large business applications. It is very friendly with database-driven web development applications.

(2) In order to use Python with MySQL we need to do two things. First, we have to install the pymysql package in python, and Second, we have to install Xampp.

(3) To install pymysql in Python, we open the command prompt and type the command pip install pymysql as shown below. The only function of this package is that it allows us to use MySQL with Python.

pip install pymysql - Python MySQL (pymysql and Xampp Installation)

(4) Now we install Xampp. It is third-party software that gives us the option to run MySQL.

(5) In order to install Xampp, go to your browser and type Xampp download as shown below.

download Xampp - Python MySQL (pymysql and Xampp Installation)

(6) You can also directly go to the official website by clicking here “Download XAMPP“. We click on the download option to download the Xampp software as shown below.

download xampp for windows - Python MySQL (pymysql and Xampp Installation)

(7) Now the Xampp software is downloaded. Go to the folder where it is downloaded as shown below.

xampp software downloaded 1 - Python MySQL (pymysql and Xampp Installation)

(8) Now double-click on the Xampp software. The computer asks “Do you want to allow this app to make changes to your device?” Click on Yes. You also receive a warning message, press Ok. Then below interface is getting opened and click on the Next button.

warning message to download xampp - Python MySQL (pymysql and Xampp Installation)
xampp setup interface opened - Python MySQL (pymysql and Xampp Installation)

(9) Then again press Next as shown below.

select components xampp - Python MySQL (pymysql and Xampp Installation)

(10) You can install it on any drive. By default, it shows C drive where xampp folder is created. If you want to install it on any other drive then create a folder in that drive and install them in that folder as shown below.

xampp install on other drive - Python MySQL (pymysql and Xampp Installation)

(11) In my case, I can install it on H drive as shown below and then press Next.

xampp install on h drive - Python MySQL (pymysql and Xampp Installation)

(11) After that select language and then press Next as shown below.

xampp select language - Python MySQL (pymysql and Xampp Installation)

(12) Then again press Next as shown below.

xampp ready to install - Python MySQL (pymysql and Xampp Installation)

(13) Now it starts installing as shown below.

xampp installing - Python MySQL (pymysql and Xampp Installation)

(14) During installation, a window security alert pops up. Press on Allow access as shown below.

window security alert - Python MySQL (pymysql and Xampp Installation)

(15) After that click on the Finish button and your xampp installation is complete.

xampp installation finish - Python MySQL (pymysql and Xampp Installation)

(16) Now opened the “Xampp” by searching in the windows search bar as shown below.

xampp - Python MySQL (pymysql and Xampp Installation)

(17) You can also open it by clicking on the xampp-control.exe which is available in the drive where you have installed the Xampp software as shown below.

xampp control open - Python MySQL (pymysql and Xampp Installation)

(18) Now Xampp Control Panel is open. Remember if you want to use Python with MySQL, you always have to press the start button of Apache and MySQL in Xampp as shown below. If a window security pop-up appears, allow access to the app.

xampp conrtol panel - Python MySQL (pymysql and Xampp Installation)

(17) After pressing the start button, Apache and MySQL are highlighted in green color which means they start working as shown below.

apache and mysql start 1 - Python MySQL (pymysql and Xampp Installation)

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

phypmyadmin localhost open - Python MySQL (pymysql and Xampp Installation)

Tutorial MySQL
Tutorial Python
Artificial Intelligence (AI)
Procedure-Oriented Programming
Object-Oriented Programming (OOP)
World Wide Web (WWW)
Python (programming language)– Wikipedia
Prev Article
Next Article

Related Articles

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

Constructors in Java

Object-Oriented Programming (OOP)
Object-Oriented Programming: The evolution of the object-oriented programming approach is …
Gk Scientist August 9, 2022 Computer

Object-Oriented Programming (OOP)

MySQL UPDATE Statement
MySQL UPDATE Statement: The primary statement used to modify the …
Gk Scientist November 15, 2022 Computer

MySQL UPDATE Statement

Secondary Storage Devices
Secondary Storage Devices: A computer is capable of storing the …
Gk Scientist August 6, 2022 Computer

Secondary Storage Devices

Python MySQL Update Query
Python MySQL Update Query: (1) Update query is used to …
Gk Scientist December 13, 2022 Computer

Python MySQL Update Query

Computer Network
What is Computer Network? Computers are generally used for the …
Gk Scientist October 8, 2022 Computer

Computer Network

Install DB Browser for SQLite on Windows
DB Browser for SQLite: (1) Go to Google chrome and …
Gk Scientist December 7, 2022 Computer

Install DB Browser for SQLite on Windows

Java Tic Tac Toe Game Project
Java Tic Tac Toe Game Project: We can use the …
Gk Scientist January 20, 2023 Computer

Java Tic Tac Toe Game Project

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 (215) Current Affairs (4) Current Content (0) Economy (17) 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...