How Tos > MySQL and Databases
How to connect to MySQL using Python
import mysql.connector
config = {
'user': 'root',
'password': 'root',
'host': 'localhost:8889',
'database': 'inventory',
'raise_on_warnings': True,
}
link = mysql.connector.connect(**config)
or using an UNIX Socket:
import mysql.connector
config = {
'user': 'root',
'password': 'root',
'unix_socket': '/Applications/MAMP/tmp/mysql/mysql.sock',
'database': 'inventory',
'raise_on_warnings': True,
}
link = mysql.connector.connect(**config)