How to check the status of a mysql connection in python?

python pymysql
Yan Song picture Yan Song · Dec 26, 2017 · Viewed 8.5k times · Source

I am using pymysql to connect to a database. I am new to database operations. Is there a status code that I can use to check if the database is open/alive, something like db.status.

Answer

alecxe picture alecxe · Dec 26, 2017

From what I see in the source code, there is the is_connected() method on a "connection" object:

Returns True when connected; False otherwise

import mysql.connector

cnx = mysql.connector.connect(user='scott', password='tiger',
                              host='127.0.0.1',
                              database='employees')
print(cnx.is_connected())

I've done a quick test - connected to the database, checked the is_connected() - it returned True, then stopped MySQL and checked the is_connected() again - returned False.

Related questions

No module named 'pymysql'

I'm trying to use PyMySQL on Ubuntu. I've installed pymysql using both pip and pip3 but every time I use import pymysql, it returns ImportError: No module named 'pymysql' I'm using Ubuntu 15.10 64-bit and Python 3.5. The same .py works on …

Read More
How to insert data to django database from views.py file?

How can I insert data to my django database from a function in the views,py file? Is python manage.py shell the only way to insert? For more explanations I'm using: python 3.4 django 1.8.2 PyMySQL For example: models.py: from …

Read More
Using python to write mysql query to csv, need to show field names

I have the following: import MySQLdb as dbapi import sys import csv dbServer='localhost' dbPass='supersecretpassword' dbSchema='dbTest' dbUser='root' dbQuery='SELECT * FROM pbTest.Orders;' db=dbapi.connect(host=dbServer,user=dbUser,passwd=dbPass) cur=db.cursor() cur.execute(…

Read More