If you are on a dev machine iterating quickly, just set the basic credentials up in ~/.mylogin.cnf[0] and you don't need to worry about supplying those options

If you are on a dev machine iterating quickly, just set the basic credentials up in ~/.mylogin.cnf[0] and you don't need to worry about supplying those options on the command line at all. [0]: https://dev.mysql.com/doc/refman/8.0/en/mysql-config-editor.html https://dev.mysql.com/doc/refman/8.0/en/mysql-config-editor....