Bug #94412 MySQL Shell with --sql mode does not properly authenticate
Submitted: 20 Feb 13:56 Modified: 26 Feb 12:29
Reporter: Oli Sennhauser Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Document Store: MySQL Shell Severity:S3 (Non-critical)
Version:8.0.15 OS:Linux (ubuntu 14.04 / fedora 29 rhel 6 and 7)
Assigned to: CPU Architecture:x86

[20 Feb 13:56] Oli Sennhauser
Description:
MySQL Shell with SQL mode does not authenticate properly when redirected over MySQL Router 8.0.15.

How to repeat:
$ ./mysqlsh --user=root --host=127.0.0.1 --port=6447 --password='' --sql --execute='select @@port'
@@port
3313
$ ./mysqlsh --user=root --host=127.0.0.1 --port=6447 --password='' --sql --execute='select @@port'
@@port
3313
$ ./mysqlsh --user=root --host=127.0.0.1 --port=6447 --password='' --sql --execute='select @@port'
@@port
3313

vs.

$ mysql --user=root --host=127.0.0.1 --port=6447 --password='' --execute='select @@port'
+--------+
|   3313 |
+--------+
$ mysql --user=root --host=127.0.0.1 --port=6447 --password='' --execute='select @@port'
+--------+
| @@port |
+--------+
|   3314 |
+--------+
$ mysql --user=root --host=127.0.0.1 --port=6447 --password='' --execute='select @@port'
+--------+
| @@port |
+--------+
|   3313 |
+--------+
[26 Feb 12:29] Umesh Shastry
Hello Oli,

Thank you for the report and feedback.

regards,
Umesh