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?

  • 1
    and you are sure that you are entering the correct password? – Orphans Jan 5 '17 at 14:39
  • 3
    You shouldn't provide the password as a parameter in a script, it will be visible for everybody who runs ps while it is running. See this question and answer on how to provide the password in a secure way. – Gerald Schneider Jan 5 '17 at 14:44
  • pass is correct, I know this isn't the best way but the reason I'm asking now is because it just doesn't work and I want to know why. – gstlouis Jan 5 '17 at 14:48
  • @GeraldSchneider mysql hides the password from ps – user9517 Jan 5 '17 at 14:51

This works for me mysql -u bas -pmysecretpassword

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

like this :

  • Sorry submited to soon – Bas van den Dikkenberg Jan 5 '17 at 18:07
  • That's a possibly useful answer, but 'structrule' is not a word, and I can't figure out what you might have intended it to be. – dave_thompson_085 Jan 8 '17 at 10:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.