error is "mysql: [Warning] Using a password on the command line interface can be insecure. Please use --connect-expired-password option or invoke mysql in interactive mode.

CodePudding user response：

You can ignore this hint, because it is considered unsafe to use mysql password in shell by default. You can

CodePudding user response：

The warning should not be ignored in production systems; ref. https://cwe.mitre.org/data/definitions/798.html

I do not understand why "exit" is relevant, nor do I know if this is your issue; but I suspect this is a real bug (the mysql folks might have assumed all systems are in production), so you should probably push back on this yourself directly--see https://bugs.mysql.com/bug.php?id=103383.

Here is one strange solution: https://www.looklinux.com/mysql-warning-using-a-password-on-the-command-line-interface-can-be-insecure/