WAMP-PHPMYADMIN USING IN PYTHON METHOD

 

Install MySQL Driver:


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":

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  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-4.9.3-py3-none-any.whl (115 kB)      |████████████████████████████████| 115 kB 6.8 MB/s Collecting wikipedia   Downloading wikipedia-1.4.0.tar.gz (27 kB) Collecting pyautogui   Downloading PyAutoGUI-0.9.52.tar.gz (55 kB)      |████████████████████████████████| 55 kB 90
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

Building RESTful APIs with Flask in PyCharm

Image
  Building RESTful APIs with Flask in PyCharm  Installing packages Once your virtualenv is ready, click the “Install” button to begin installing packages. We’ll be installing three packages for our project: Flask  (install either by pycharms STTINGS-----PYTHON INTERPRETOR (+)) Flask-Restless  (for building the RESTful API) Flask-SQLAlchemy  (for connecting to our database) || OR  MySQLdb In Pycharms (Main.py):write below code here change parameters as per your database: import flask from flask import Flask, json, request, jsonify from flask_mysqldb import MySQL, MySQLdb # pip install flask-mysqldb https://github.com/alexferl/flask-mysqldb app = Flask(__name__) app.secret_key = "2021" app.config[ 'MYSQL_HOST' ] = 'localhost' app.config[ 'MYSQL_USER' ] = 'root' app.config[ 'MYSQL_PASSWORD' ] = '' app.config[ 'MYSQL_DB' ] = 'entry_system' app.config[ 'MYSQL_CURSORCLASS' ] = 'DictCursor' mysql = MyS
Read more