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', password='password',
6                                host='127.0.0.1',
7                                database='employees')
8except mysql.connector.Error as err:
9  if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:
10    print("Something is wrong with your user name or password")
11  elif err.errno == errorcode.ER_BAD_DB_ERROR:
12    print("Database does not exist")
13  else:
14    print(err)
15else:
16  cnx.close()