connecting to mysql using connector 2fpython

1pip3 install mysql-connector-python  #Python 3
2pip install mysql-connector-python 

1# real nice guide, as well as instalation guide: https://pynative.com/python-mysql-database-connection/
2# pip install mysql-connector-python
3import mysql.connector
4from mysql.connector import Error
5
6try:
7    connection = mysql.connector.connect(host='localhost',
8                                         database='Electronics',
9                                         user='pynative',
10                                         password='pynative@#29')
11    if connection.is_connected():
12        db_Info = connection.get_server_info()
13        print("Connected to MySQL Server version ", db_Info)
14        cursor = connection.cursor()
15        cursor.execute("select database();")
16        record = cursor.fetchone()
17        print("You're connected to database: ", record)
18
19except Error as e:
20    print("Error while connecting to MySQL", e)
21finally:
22    if (connection.is_connected()):
23        cursor.close()
24        connection.close()
25        print("MySQL connection is closed")

1import mysql.connector
2
3cnx = mysql.connector.connect(user='scott', password='password',
4                              host='127.0.0.1',
5                              database='employees')
6cnx.close()

1import mysql.connector
2
3mydb = mysql.connector.connect(
4  host="localhost",
5  user="yourusername",
6  password="yourpassword"
7)
8
9print(mydb)

1Press CTRL+C to copy import datetime
2import mysql.connector
3
4cnx = mysql.connector.connect(user='scott', database='employees')
5cursor = cnx.cursor()
6
7query = ("SELECT first_name, last_name, hire_date FROM employees "
8         "WHERE hire_date BETWEEN %s AND %s")
9
10hire_start = datetime.date(1999, 1, 1)
11hire_end = datetime.date(1999, 12, 31)
12
13cursor.execute(query, (hire_start, hire_end))
14
15for (first_name, last_name, hire_date) in cursor:
16  print("{}, {} was hired on {:%d %b %Y}".format(
17    last_name, first_name, hire_date))
18
19cursor.close()
20cnx.close()

1import mysql.connector
2try:
3    connection = mysql.connector.connect(host='localhost',database='dbname',user='root',password='xxxxx')
4    # print(dir(connection))
5    # print(connection.connection_id)
6    if connection.is_connected():
7        db_Info = connection.get_server_info()
8        print("Connected to MySQL Server version ", db_Info)
9        cursor = connection.cursor()
10        cursor.execute("select database();")
11        record = cursor.fetchone()
12        print("You're connected to database: ", record)
13except Error as e:
14    print("except")
15    print("Error while connecting to MySQL", e)
16finally:
17    if (connection.is_connected()):
18        cursor.close()
19        connection.close()
20        print("MySQL connection is closed")