Python MySQL with WAMP

 Install MySQL Driver

Python is a high-level, general-purpose, and very popular programming language. Basically, it was designed with an emphasis on code readability, and programmers can express their concepts in fewer lines of code. We can also use Python with SQL. In this article, we will learn how to connect SQL with Python using the ‘MySQL Connector Python module. The diagram given below illustrates how a connection request is sent to MySQL connector Python, how it gets accepted from the database and how the cursor is executed with result data.

Move to ur Python Scripts location



Microsoft Windows [Version 10.0.18363.1256]
(c) 2019 Microsoft Corporation. All rights reserved.

C:\Users\RCF>cd..

C:\Users>cd..

C:\>cd Python3.9.1

C:\Python3.9.1>cd Scripts

C:\Python3.9.1\Scripts>python -m pip install mysql-connector-python
Collecting mysql-connector-python
  Downloading mysql_connector_python-8.0.22-py2.py3-none-any.whl (374 kB)
     |████████████████████████████████| 374 kB 6.4 MB/s
Collecting protobuf>=3.0.0
  Downloading protobuf-3.14.0-py2.py3-none-any.whl (173 kB)
     |████████████████████████████████| 173 kB 6.4 MB/s
Collecting six>=1.9
  Downloading six-1.15.0-py2.py3-none-any.whl (10 kB)
Installing collected packages: six, protobuf, mysql-connector-python
Successfully installed mysql-connector-python-8.0.22 protobuf-3.14.0 six-1.15.0
WARNING: You are using pip version 20.2.3; however, version 20.3.3 is available.
You should consider upgrading via the 'C:\Python3.9.1\python.exe -m pip install --upgrade pip' command.

C:\Python3.9.1\Scripts>

Download and install "MySQL Connector":

Connecting MySQL with Python

To create a connection between the MySQL database and Python, the connect() method of mysql.connector module is used. We pass the database details like HostName, username, and the password in the method call, and then the method returns the connection object.

The following steps are required to connect SQL with Python:

Step 1: Download and Install the free MySQL database

Step 2: After installing the MySQL database, open your Command prompt.

Step 3: Navigate your Command prompt to the location of PIP. Click here to see

Step 4: Now run the commands given below to download and install “MySQL Connector”. Here, mysql.connector statement will help you to communicate with the MySQL database.

C:\Users\Your Name\AppData\Local\Programs\Python\Python36-32\Scripts>python -m pip install mysql-connector-python

Test MySQL Connector

open file location like i did as :

http://localhost:81/python/configcheck.py

#!C:/Python3.9.1/python.exe

print("content-type: text/html\n\n" )


import mysql.connector

mydb = mysql.connector.connect(
  host="localhost",
  user="root",
  password="",
  database="rcf_entry_system"
)

mycursor = mydb.cursor()



mycursor.execute("SHOW TABLES")

for x in mycursor:
  print(x)

Comments

Post a Comment

Popular posts from this blog

Python to automate What's App messages

Image
 Python to automate What's App messages  We can automate a Python script to send WhatsApp messages. In this article, we will learn the easiest ways using pywhatkit module that the website web.whatsapp.com uses to automate the sending of messages to any WhatsApp number. Send WhatsApp Messages  : We can automate WhatsApp to send messages by running a python script.  Now let's setup  pywhatkit  module and write the code to send WhatsApp message automatically. Install pywhatkit module: To install the pywhatkit module, we can use the pip command: pip install pywhatkit This command will download the  pywhatkit  module. It will take some time as it will download some related modules too. LIKE BELOW SCRIPT WILL RUN AUTOMATICALLY:::: (venv) C:\Users\RCF\PycharmProjects\pywhatkitWhatsAppAutomate>pip install pywhatkit Collecting pywhatkit   Downloading pywhatkit-3.9-py3-none-any.whl (9.1 kB) Collecting beautifulsoup4   Downloading beautifulsoup4...
Read more

Redirecting to another page with button click in Python-flask

Image
  Redirecting to another page with  click in Python-flask Suppose we have to attach any html page Link in any webpage in python  < a class ="dropdown-item" href = "{{ url_for('terms') }}" >< span class ="item-text" > Terms Conditions </ span ></ a > < div class ="dropdown-items-divide-hr" ></ div > < a class ="dropdown-item" href = "{{ url_for('privacy') }}" >< span class ="item-text" > Privacy Policy </ span ></ a > THEN GO TO UR MAIN.PY PAGE : @app.route ( '/terms' )===> it is the name of file which we have mentioned inside href of above def terms():====> keep it same as name above return render_template( 'terms-conditions.html' )====then this page will open when click avove link::: Terms Conditions - Evolo - StartUp HTML Landing Page Template @app.route ( '/privacy' ) ===> it is the nam...
Read more

Install WAMP server to run python

Image
 Install WAMP + PYTHON Integration I'd be glad to assist you with installing WAMP server to run Python. However, it's important to note that WAMP is primarily designed for running PHP applications, and Python typically has its own dedicated environments like Anaconda or virtual environments. Important Considerations: WAMP's Primary Purpose: WAMP is primarily designed for running PHP applications. Using it for Python might not be the most optimal or efficient approach. Dedicated Python Environments: For dedicated Python development, consider using Python-specific environments like Anaconda or virtual environments. These environments provide better control over Python versions and packages. Web Framework Choice: If you need to run Python web applications, carefully evaluate the features and requirements of different web frameworks to choose the best one for your project. How to set up wamp to run Python programs and php on your own computer. SQL works also. Only tested on ...
Read more