mysql 创建备份用户名和密码错误,mysql 备份报错mysqldump: [Warning] Using a password on the command line interface can...

--------------------------------------------------------------------------------

mysql 备份报错mysqldump: [Warning] Using a password on the command line interface can be insecure.

备份某个表步骤如下

解决办法：修改my.ini配置添加以下语句

[mysqldump]

user=root ----为备份用户名

password=123!@#   ----为用户密码

然后mysqldump  ipos  table > c:\bak.sql   备份Ipos 下的表table  到目录 c:\bak.sql

mysqldump -u root   -p --databases  databasenam2 databasename2 >  all.sql

----------------------------------------------------------------

原文：https://www.cnblogs.com/aaronguo/p/10056002.html