解决MySQL5.6出现"Using a password on the command line interface..."

小渣渣

mysqldump: [Warning] Using a password on the command line interface can be insecure.

mysql数据库备份和导出
http://www.itsvse.com/thread-4004-1-1.html
(出处: 架构师_程序员)

以前都是用mysqldump导出，现在为啥不能用了，好像是mysql5.6版本就不能用了，以前的老版本都可以使用！


在官网文档找到了缘由，大家可以点击这里看看：http://dev.mysql.com/doc/refman/5.1/en/password-security-user.html

MySQL users should use the following guidelines to keep passwords secure.

    When you run a client program to connect to the MySQL server, it is inadvisable to specify your password in a way that exposes it to discovery by other users. The methods you can use to specify your password when you run client programs are listed here, along with an assessment of the risks of each method. In short, the safest methods are to have the client program prompt for the password or to specify the password in a properly protected option file.

英文有点烂，但大概读懂意思，翻译过来大意是在命令行下如果要使用密码可以在执行命令后的提示输入里输入密码，或者在指定的安全文件内指定密码。那安全文件时哪个呢？文档对此给出了答案：

Store your password in an option file. For example, on Unix, you can list your password in the [client] section of the .my.cnf file in your home directory。

解决办法：

我们C:\ProgramData\MySQL\MySQL Server 5.7文件目录，找到了my.ini文件，最下面增加如下配置：

登录可见。

然后，执行导出命令，这里我导出mydb为例：

登录可见。

成功！