Bug #96305 cloning: Make CLONE INSTANCE ':port' part optional and default to 3306
Submitted: 24 Jul 7:42 Modified: 25 Jul 6:45
Reporter: Simon Mudd (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Clone Plugin Severity:S4 (Feature request)
Version:8.0.17 OS:Any
Assigned to: CPU Architecture:Any
Triage: Needs Triage: D5 (Feature request)

[24 Jul 7:42] Simon Mudd
Description:
The CLONE INSTANCE SYNTAX requires user@host:port as parameters. MySQL has a default port of 3306 so I would suggest that this last part the port) should be optional and default to 3306.

How to repeat:
See: https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-remote.html

Current syntax is:

CLONE INSTANCE FROM USER@HOST:PORT
IDENTIFIED BY 'password'
[DATA DIRECTORY [=] 'clone_dir']
[REQUIRE [NO] SSL];

Suggested fix:
Suggestion is to support the syntax:

CLONE INSTANCE FROM USER@HOST[:PORT]
IDENTIFIED BY 'password'
[DATA DIRECTORY [=] 'clone_dir']
[REQUIRE [NO] SSL];

and if not provided use port 3306 (default mysql port) as the default.
[25 Jul 6:45] Umesh Shastry
Hello Simon,

Thank you for the reasonable feature request!

regards,
Umesh