You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
25 lines
755 B
25 lines
755 B
import mysql.connector
|
|
from mysql.connector import Error
|
|
import configparser
|
|
|
|
def load_config():
|
|
config = configparser.ConfigParser()
|
|
config.read('config.ini')
|
|
return config
|
|
|
|
def connect_to_database():
|
|
try:
|
|
config = load_config()
|
|
connection = mysql.connector.connect(
|
|
host=config['database']['host'],
|
|
database=config['database']['database'],
|
|
user=config['database']['user'],
|
|
password=config['database']['password']
|
|
)
|
|
if connection.is_connected():
|
|
print("Connected to the database successfully!")
|
|
return connection
|
|
except Error as e:
|
|
print(f"Error while connecting to database: {e}")
|
|
return None
|