mysql_connector_python_database_connection_with_error_handling.py

1import mysql.connector
2from mysql.connector import errorcode
3
4try:
5  cnx = mysql.connector.connect(user='scott', 
6                                password='password',
7                                host='127.0.0.1',
8                                database='employees')
9except mysql.connector.Error as err:
10  if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:
11    print("Something is wrong with your user name or password")
12  elif err.errno == errorcode.ER_BAD_DB_ERROR:
13    print("Database does not exist")
14  else:
15    print(err)
16else:
17  cnx.close()