Connect mysql with Python - mrolarik/simple-iot GitHub Wiki

$ sudo python -m pip install mysql-connector

>>> import mysql.connector
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
ImportError: No module named mysql.connector

mydb = mysql.connector

mydb = mysql.connector.connect(
  host="localhost",
  user="myusername",
  passwd="mypassword",
  database="iot_device"
)

print(mydb)

<mysql.connector.connection.MySQLConnection object ar 0x016645F0> 

mycursor = mydb.cursor()
mycursor.execute("SHOW TABLES")

# show table name
for x in mycursor:
    print(x)

(u'iot',)

sql = 'INSERT INTO iot(iot_name, iot_value1, iot_value2) VALUES (%s, %s, %s)'
val = ('TEMP', '20', '25')
mycursor.execute(sql, val)

mydb.commit()
print(mycursor.rowcount, "record inserted.")

(1, 'record inserted.')

#----------connect_mysql.py------------

mydb = mysql.connector.connect(
  host="localhost",
  user="myusername",
  passwd="mypassword",
  database="iot_device"
)
mycursor = mydb.cursor()

sql = 'INSERT INTO iot(iot_name, iot_value1, iot_value2) VALUES (%s, %s, %s)'
val = ('TEMP', '20', '25')
mycursor.execute(sql, val)

mydb.commit()
print(mycursor.rowcount, "record inserted.")

$ python connect_mysql.py