Checking if database connected to Python

Question

I try to connect to mysql database using mysql.connector.connect(), I checked if all arguments passed to function are ok and they are. I want the output of this code to confirm the connection made to database. I run this in PyCharm and nothing happens, just waiting for something... MySQL Workbench is all set up, I mean the connection is tested and it works well.

import mysql.connector

db = mysql.connector.connect(host="localhost", user="root", password="Asdf124#")
if (db):
    print("connected")
else:
    print("fail")

Is this Answers your question ?

nakE
– nakE

2020-02-08 10:32:31 +00:00
Commented Feb 8, 2020 at 10:32 — nakE
– nakE, Commented Feb 8, 2020 at 10:32

James Stone · Accepted Answer · 2020-02-08 10:34:43Z

0

As from examples in the docs:

import mysql.connector
from mysql.connector import errorcode

try:
  cnx = mysql.connector.connect(user='scott',
                                database='employ')
except mysql.connector.Error as err:
  if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:
    print("Something is wrong with your user name or password")
  elif err.errno == errorcode.ER_BAD_DB_ERROR:
    print("Database does not exist")
  else:
    print(err)
else:
  cnx.close()

This is the proper way to handle exceptions when connecting to the database.

answered Feb 8, 2020 at 10:34

James Stone

1381 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Checking if database connected to Python

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related