pip install mycli
python
import mycli
config = {
'host': 'localhost',
'port': 3306,
'user': 'root',
'password': 'password',
'database': 'my_database',
'ssl-ca': '/path/to/ca/file.crt',
'auto-vertical-output': True
}
conn = mycli.connect(**config)
cursor = conn.cursor()
query = "SELECT * FROM my_table"
cursor.execute(query)
result = cursor.fetchall()
for row in result:
print(row)
cursor.close()
conn.close()
