Bug #91326 Invalid syntax in account name
Submitted: 20 Jun 2018 10:34 Modified: 25 Sep 2018 13:14
Reporter: Shane Bester (Platinum Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:Shell Upgrade Checker Severity:S3 (Non-critical)
Version:8.0.11 OS:Any
Assigned to: CPU Architecture:Any

[20 Jun 2018 10:34] Shane Bester
Description:
Seeing this...

E:\mysql-shell-8.0.11-windows-x86-64bit\bin>mysqlsh root:@localhost:3306 -e "util.checkForServerUpgrade();"
mysqlsh: [Warning] Using a password on the command line interface can be insecure.
The MySQL server at localhost:3306 will now be checked for compatibility issues for upgrade to MySQL 8.0...
Util.checkForServerUpgrade: Invalid syntax in account name 'skip-grants user@skip-grants host' (RuntimeError)
 at (command line):1:5
in util.checkForServerUpgrade();
        ^

How to repeat:
Start 5.7 with --skip-grant-tables and run the upgrade checker...

Suggested fix:
Quote account name?
[20 Jun 2018 10:39] MySQL Verification Team
Hello Shane,

Thank you for the report.

Regards,
umesh
[25 Sep 2018 13:14] Margaret Fisher
Posted by developer:
 
Changelog entry added for MySQL Shell 8.0.13:

The upgrade checker utility provided by MySQL Shell (the util.checkForServerUpgrade() operation) now correctly handles account names with spaces and other blank characters, and skips the permissions check when the server was started with the --skip-grant-tables option.
[12 Nov 2019 7:04] Hussain patel
i am facing the same issue in 8.0.17

can you please check