Bug #93003 Support --defaults-extra-file and --defaults-file
Submitted: 30 Oct 2018 7:23 Modified: 2 Feb 13:56
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Shell General / Core Client Severity:S4 (Feature request)
Version:8.0.12, 8.0.13 OS:Any
Assigned to: CPU Architecture:Any
Triage: Needs Triage: D5 (Feature request)

[30 Oct 2018 7:23] Daniël van Eeden
Description:
The "store your password in an option file" as described on https://dev.mysql.com/doc/refman/8.0/en/password-security-user.html doesn't work for mysqlsh as it support neither --defaults-extra-file nor --defaults-file

This is in most cases more secure than specifying the password on the command line.

How to repeat:
Try to use an option file to store the password for mysqlsh

Suggested fix:
Support --defaults-extra-file and --defaults-file
[30 Oct 2018 9:51] Umesh Shastry
Hello Daniël,

Thank you for the reasonable feature request!

regards,
Umesh
[2 Feb 13:56] Daniël van Eeden
I wrote a credential helper to at least read ~/.my.cnf
https://github.com/dveeden/mysql-secret-store-mycnf

Would be nice to have something like this shipped with mysql-shell