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

环境:win7

mysql版本

mysql> select version();
+------------+
| version() |
+------------+
| 5.7.26-log |
+------------+
1 row in set

在执行mysqldump命令时,出现如下错误

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

解决方法:

  添加用户baby,密码 xyz123 并赋予要备份的数据库全部权限

  修改my.ini

[client]
port = 3306
host = localhost
user = baby
password = 'xyz123'

重启mysql

 

posted @ 2019-11-19 15:13  慕尘  阅读(2847)  评论(0编辑  收藏  举报