mysql_connector_python_basic_connection_and_version_query.py

1import mysql.connector
2
3# Connect to the MySQL server
4try:
5    connection = mysql.connector.connect(
6        user='scott',
7        password='password',
8        host='127.0.0.1',
9        database='employees'
10    )
11
12    if connection.is_connected():
13        db_info = connection.get_server_info()
14        print("Connected to MySQL Server version ", db_info)
15        cursor = connection.cursor()
16        cursor.execute("select database();")
17        record = cursor.fetchone()
18        print("You're connected to database: ", record)
19
20except mysql.connector.Error as err:
21    print("Error while connecting to MySQL", err)
22
23finally:
24    if 'connection' in locals() and connection.is_connected():
25        cursor.close()
26        connection.close()
27        print("MySQL connection is closed")