An issue with Exporting DB

[agz]

Hi there,

OS: CentOS
Version: CWP7 Pro

I'm unable to export DB for a user using SSH and getting " Got error: 1045: "Access denied for user ".
Can someone please explain how to solve this issue?

Note: the DB was created by the same user and I'm using its' password to export it.

[overseer]

You're using mysqldump via an SSH session (using user credentials)? As a workaround, can you export as root? Or have you tried phpMyAdmin?

[agz]

You're using mysqldump via an SSH session (using user credentials)? 

Yes

As a workaround, can you export as root?

yes, but How can a client do it without root access.

Or have you tried phpMyAdmin?

No, because I think this should work.

[rcschaff]

Are you able to connect to mysql via the user/password?

If yes, add "   --single-transaction  " to mysqldump, as the user doesn't have lock table privileges