mysql password on command line

Question

I can't seem to be this working. I wanted to set a shell script for mysqldump backup some databases.

I have tried:

mysqldump -uroot -ppassword

mysqldump -u root -ppassword <-- online A's says this is supposed to work

mysqldump --user=root --password=password

I keep getting access denied for user root@localhost

if I do the old fashion mysqldump -uroot -p and enter pass all is good

centos 6.8 mysql 5.7 I did install mysql manually with: http://www.tecmint.com/install-latest-mysql-on-rhel-centos-and-fedora/#

is there a mysql option that disables this?

Answer 1

This works for me mysql -u bas -pmysecretpassword

if its for structrule use you can put your password in my.cnf file

like this :

[mysqldump]
user=bas
password=mysecretpassword