Python simple connect to mysql

Connect python to mysql

import mysql.connector
mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  port = 8888, #for Mamp users
  database='whatever db you want'
)
print(mydb)

Python simple connect to mysql

import pymysql.cursors
import pymysql

# Connect to the database
connection = pymysql.connect(host='localhost',
                             user='user',
                             password='passwd',
                             db='db',
                             charset='utf8mb4',
                             cursorclass=pymysql.cursors.DictCursor)

try:
    with connection.cursor() as cursor:
        # Create a new record
        sql = "INSERT INTO `users` (`email`, `password`) VALUES (%s, %s)"
        cursor.execute(sql, ('webmaster@python.org', 'very-secret'))

    # connection is not autocommit by default. So you must commit to save
    # your changes.
    connection.commit()

    with connection.cursor() as cursor:
        # Read a single record
        sql = "SELECT `id`, `password` FROM `users` WHERE `email`=%s"
        cursor.execute(sql, ('webmaster@python.org',))
        result = cursor.fetchone()
        print(result)
finally:
    connection.close()

Source: stackoverflow.com

Similar codes

0 vote267 views1 answer
Mysql workbench not showing schemas
SQL
0 vote301 views1 answer
Sqlite3_open_v2
SQL
1 vote299 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
18 votes280 views6 answers
Create table mysql
SQL
20 votes284 views3 answers
SQL query rename table
SQL
0 vote309 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
3 votes283 views2 answers
Mysql config user password
SQL
0 vote267 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
0 vote270 views1 answer
Alter table name including schema
SQL
0 vote268 views1 answer
Get time component of datetime sql
SQL