mysqldump

xml

• January 05, 2015 04:04

Hello from user account shell and for years I been using this comandline mysqldump --opt -Q "uusername "ppassword database_name > Backup.sql lately that comandline isnt working any more and get this error message: mysqldump: Got error: 1044: Access denied for user 'user'@'localhost' to database '"uusername' when selecting the database But I found this comandline is working: mysqldump --opt -Q database_name > Backup.sql why the first comandline is not working any more? and why the second comandline is working without username and password, isnt it security risk? CENTOS 6.6 x86_64 standard WHM 11.44.1 (build 23)

• 

  cPanelMichael

  • January 07, 2015 14:46

  Hello :) You should already have authenticated into the account when you accessed SSH so you should be able to simply run:
  mysqldump --opt -Q database_name > Backup.sql
  Thank you.

  0

Please sign in to leave a comment.