Bug #92712 SHUTDOWN COMMAND NOT ALLOWED BY XPLUGN CONNECTION
Submitted: 8 Oct 2018 23:20 Modified: 8 Oct 2018 23:21
Reporter: Jesper wisborg Krogh Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Document Store: X Plugin Severity:S3 (Non-critical)
Version:5.7.23 OS:Any
Assigned to: CPU Architecture:Any

[8 Oct 2018 23:20] Jesper wisborg Krogh 
Description:
MySQL 5.7 and 8.0 supports the SHUTDOWN command. However, it is not supported when connecting using the X Protocol:

ERROR: 3130: Command not supported by pluggable protocols

How to repeat:
1. Connect to MySQL with MySQL Shell using the X protocol or using the X DevAPI from a connector. E.g. with Connector/Python 8.0.12:

import mysqlx

connect_args = {
    "user": "root",
    "password": "password",
    "host": "127.0.0.1",
    "port": 33060,
}

db = mysqlx.get_session(**connect_args)
result = db.sql("SHUTDOWN").execute()
db.close()

Causes:

mysqlx.errors.OperationalError: Command not supported by pluggable protocols

2. Execute the SHUTDOWN statement or program.

Suggested fix:
Add support for executing the SHUTDOWN command through the X Protocol.