Installez au préalable Mysql, le plus rapide (avec zéro configuration ) étant d’installer la solution de développement PHP Laragon si vous êtes sous windows.
Ensuite il faudra redéfinir le mot de passe root, allez dans Laragon click droit sur le bouton Database > Mysql > Change root password.
Connexion à Mysql en Python
from mysql.connector import MySQLConnection, Error
def connect():
""" Connect to MySQL database """
conn = None
try:
conn = mysql.connector.connect(host='localhost',
database='boutique',
user='root',
password='root')
if conn.is_connected():
print('Connected to MySQL database')
except Error as e:
print(e)
finally:
if conn is not None and conn.is_connected():
conn.close()
if __name__ == '__main__':
connect()
Exécuter une requête SQL en Python
from mysql.connector import MySQLConnection, Error
def query_with_fetchone():
try:
conn = MySQLConnection(host='localhost',
database='boutique',
user='root',
password='root')
cursor = conn.cursor()
cursor.execute("SELECT * FROM staffs")
row = cursor.fetchone()
while row is not None:
print(row)
row = cursor.fetchone()
except Error as e:
print(e)
finally:
cursor.close()
conn.close()
query_with_fetchone()