CR

CrispenGari/mysql-python

🎨 this repository contains some mysql and python examples.

mysql mysql-databases mysql-server python python-mysql-connector

MySQL Python

In this one we are going to learn how we can configure python to connect with mysql server.

Installing MSQL Connector

pip install mysql-connector-python

Testing the connection.

To test the connection create a python file and add the following code in it:

from mysql import connector

config ={
    'host': '127.0.0.1' or 'localhost',
    'user': 'root',
    'password': 'root',
    'database': 'todos',
    'port': 3306
}
conn = connector.connect(**config)
# closing the connection
conn.close()

Refs

On this page

Languages

Python100.0%

Contributors

MIT License

Created August 23, 2022

Updated August 23, 2022