class_docstr: Test mindsdb mysql api.
  All sql commands are being executed through binary mode of mysql protocol.
  This class inherits all tests from TestMySqlApi:
  -k 'not TestMySqlApi' is required for test launch.
  Otherwise inherited tests will be executed twice:
  First one for TestMySqlApi, second one for TestMysqlBinApi
  In general all tests do next:
      1. Do some preconditions
      2. Specify SQL query needs to be executed
      3. Send the query to a Mindsdb app in binary mode and execute the query
code: def query(self, _query, encoding="utf-8"):
      cnx = mysql.connector.connect(
          host=self.config["api"]["mysql"]["host"],
          port=self.config["api"]["mysql"]["port"],
          database="mindsdb",
          user=self.config["auth"]["username"],
          password=self.config["auth"]["password"],
      )
      cursor = cnx.cursor(prepared=True)
  
      for subquery in _query.split(";"):
          # multiple queries in one string
          if subquery.strip() == "":
              continue
          cursor.execute(subquery)
  
      if cursor.description:
          columns = [i[0] for i in cursor.description]
          data = cursor.fetchall()
  
          res = Dlist()
          for row in data:
              res.append(dict(zip(columns, row)))
  
      else:
          res = {}
  
      return res
  
file_path: mindsdb/tests/integration_tests/flows/test_mysql_bin_api.py
imports: import json
  from pathlib import Path
  import mysql.connector
  import pytest
  from .test_mysql_api import TestMySqlApi, Dlist
label_desc: Use image node_id 1 for calling the TestMySqlBinApi obj's underlying member method code with example usage: obj.query(_query, encoding) and returns: res