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

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

Enter the password on the command line , You'll be prompted with these security warnings .

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

notes : mysql -u root -pPASSWORD or mysqldump -u root -pPASSWORD Will output such a warning message .

1、 in the light of mysql

mysql -u root -pPASSWORD Change to mysql -u root -p Just enter the password .

2、mysqldump It's a little bit more complicated , It's usually written in scripts Script .

resolvent ：

about mysqldump How to avoid (Warning: Using a password on the command line interface can be insecure.) Warning messages ?

vim /etc/mysql/my.cnf

[mysqldump]

user=your_backup_user_name

password=your_backup_password

After modifying the configuration file , Just execute mysqldump Scripts will do . The backup script does not need to involve user name and password information