Ansluta Python till MySQL

Steg-för-steg-guide

• Installera MySQL-anslutning
  • MySQL Connector: pip install mysql-connector-python
  • PyMySQL: pip install PyMySQL
  • SQLAlchemy: pip install sqlalchemy
• Skapa en anslutningsobjekt

    import mysql.connector
  
    cnx = mysql.connector.connect(
        host="localhost",
        user="root",
        password="your_password"
    )
  

• Hämta en markör

   cursor = cnx.cursor()
  

• Kör SQL-kommandon

   cursor.execute("SELECT * FROM users")
  

• Hämta resultat

   for row in cursor:
       print(row)
  

• Stäng anslutningen

   cursor.close()
   cnx.close()
  

Exempel

import mysql.connector

cnx = mysql.connector.connect(
    host="localhost",
    user="root",
    password="your_password",
    database="your_database"
)

cursor = cnx.cursor()
cursor.execute("SELECT * FROM users")

for row in cursor:
    print(row)

cursor.close()
cnx.close()