class_docstr: This handler handles connection and execution of the MySQL statements.
class_docstr_tok: ["This","handler","handles","connection","and","execution","of","the","MySQL","statements","."]
docstr: Check the connection of the MySQL database
  :return: success status and error message if error occurs
docstr_tok: ["Check","the","connection","of","the","MySQL","database",":","return",":","success","status","and","error","message","if","error","occurs"]
code: def check_connection(self) -> StatusResponse:
      """
      Check the connection of the MySQL database
      :return: success status and error message if error occurs
      """
  
      result = StatusResponse(False)
      need_to_close = self.is_connected is False
  
      try:
          connection = self.connect()
          result.success = connection.is_connected()
      except Exception as e:
          logger.error(
              f'Error connecting to MySQL {self.connection_data["database"]}, {e}!'
          )
          result.error_message = str(e)
  
      if result.success is True and need_to_close:
          self.disconnect()
      if result.success is False and self.is_connected is True:
          self.is_connected = False
  
      return result
  
imports: from collections import OrderedDict
  import pandas
  import mysql.connector
  from urllib.parse import urlparse
  from sqlalchemy import create_engine
  from mindsdb_sql import parse_sql
  from mindsdb_sql.render.sqlalchemy_render import SqlalchemyRender
  from mindsdb_sql.parser.ast.base import ASTNode
  from mindsdb.utilities import log
  from mindsdb.integrations.libs.base import DatabaseHandler
  from mindsdb.integrations.libs.response import HandlerStatusResponse, HandlerResponse, RESPONSE_TYPE
  from mindsdb.integrations.libs.const import HANDLER_CONNECTION_ARG_TYPE
label_desc: Use image node_id 6 for calling the MySQLHandler obj's underlying member method code with example usage: obj.check_connection() and returns: result