Solution MySQL5.6 warning:using A password on the command line interface can be insecure

MySQL5.6 when using the password of the name of the login, will appear:warning:using a password on the command line interface can be insecure

Of course this will not matter to the normal landing, if used in the script, there will be problems;

The way to solve this problem is to configure it in MY.CNF;

Add the following configuration to the MY.CNF

[Mysqladump]user=my_namepassword=my_pass

Restart MySQL

You don't need to add any more parameters to use the Mysqldump command later.

Example: Mysqldump db > Mysql_bak.sql

The-U and-p parameters are omitted.

This article from the "Shallow faint" blog, please be sure to keep this source http://cuixiang.blog.51cto.com/8204722/1725818

Solution MySQL5.6 warning:using A password on the command line interface can be insecure