Bug #91798 MySQL utilities 1.6.5 not working with MySQL 8
Submitted: 26 Jul 2018 9:58 Modified: 14 Aug 2018 10:52
Reporter: 伍嘉成 JiaChengWu Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Utilities Severity:S1 (Critical)
Version:8.0.11, 8.0.12 OS:CentOS (CentOS 7.2)
Assigned to: Assigned Account CPU Architecture:Any (x64)

[26 Jul 2018 9:58] 伍嘉成 JiaChengWu
Description:
I try to use mysql utilities 1.6.5 in CentOS 7.2(python 2.7)+mysql 8.0.11, 
but it does work as shown:
[root@localhost ~]# mysqldiskusage --server=root:123456@localhost
WARNING: Using a password on the command line interface can be insecure.
# Source on localhost: ... 
Traceback (most recent call last):
  File "/usr/bin/mysqldiskusage", line 126, in <module>
    servers = connect_servers(source_values, None)
  File "/usr/lib64/python2.7/site-packages/mysql/utilities/common/server.py", line 489, in connect_servers
    source = get_server(src_name, src_dict, quiet, verbose=verbose)
  File "/usr/lib64/python2.7/site-packages/mysql/utilities/common/server.py", line 336, in get_server
    server_conn.connect()
  File "/usr/lib64/python2.7/site-packages/mysql/utilities/common/server.py", line 1104, in connect
    res = self.show_server_variable('character_set_client')
  File "/usr/lib64/python2.7/site-packages/mysql/utilities/common/server.py", line 1391, in show_server_variable
    return self.exec_query("SHOW VARIABLES LIKE '%s'" % variable)
  File "/usr/lib64/python2.7/site-packages/mysql/utilities/common/server.py", line 1327, in exec_query
    cur.close()
  File "/usr/lib64/python2.7/site-packages/mysql/connector/cursor.py", line 395, in close
    self._connection.handle_unread_result()
  File "/usr/lib64/python2.7/site-packages/mysql/connector/connection_cext.py", line 599, in handle_unread_result
    raise errors.InternalError("Unread result found")
mysql.connector.errors.InternalError: Unread result found

How to repeat:
[root@localhost ~]# rpm -qa|grep mysql
mysql-connector-python-cext-8.0.11-1.el7.x86_64
mysql-connector-python-8.0.11-1.el7.x86_64
mysql-utilities-1.6.5-1.el7.noarch

[root@localhost ~]# python
Python 2.7.5 (default, Nov 20 2015, 02:00:19) 
[GCC 4.8.5 20150623 (Red Hat 4.8.5-4)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> 

[root@localhost ~]# uname -a
Linux localhost.localdomain 3.10.0-327.el7.x86_64 #1 SMP Thu Nov 19 22:10:57 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux

[root@localhost ~]# cat /etc/redhat-release 
CentOS Linux release 7.2.1511 (Core)
[14 Aug 2018 10:52] Umesh Shastry
Hello JiaChengWu,

Thank you for the report!
Verified as described.

Thanks,
Umesh