mysql 5.6 登录警告_MYSQL 5.6版本 mysqldump备份数据，提示警告“Using a password...”...

最新推荐文章于 2023-03-30 10:56:59 发布

赖黹

最新推荐文章于 2023-03-30 10:56:59 发布

阅读量170

点赞数

文章标签： mysql 5.6 登录警告

本文链接：https://blog.csdn.net/weixin_29168813/article/details/114744439

版权

mysql 5.6版本之后，使用 mysqldump dbName -r - p > bs.sql 会报警告。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.

大意就是，在命令行输入密码，不安全。因此，它也给出了几个解决方案。

其中就用利用my.cnf(linux下)/my.ini(window)加入密码的写法。[client]

host=your_host

user=your_user

password=your_pass

对应的，mysqldump的备份写法是如下：mysqldump --defaults-extra-file=../my.ini dbName >dbName.sql