Control Web Panel

WebPanel => MySQL => Topic started by: agz on November 18, 2023, 04:00:53 PM

Title: An issue with Exporting DB
Post by: agz on November 18, 2023, 04:00:53 PM

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.

Title: Re: An issue with Exporting DB
Post by: overseer on November 18, 2023, 05:57:45 PM

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

Title: Re: An issue with Exporting DB
Post by: agz on November 18, 2023, 08:18:33 PM

Quote from: overseer on November 18, 2023, 05:57:45 PM

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

Yes

Quote

As a workaround, can you export as root?

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

Quote

Or have you tried phpMyAdmin?

No, because I think this should work.

Title: Re: An issue with Exporting DB
Post by: rcschaff on November 20, 2023, 03:27:21 AM

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