Lightsail Instance Data Import To Lightsail Database: ERROR 1045 (28000): Access denied for user

0

I keep getting denied when entering MySQL password after executing the following command (example):

sudo mysqldump -u root --databases bitnami_wordpress --single-transaction --compress --order-by-primary -p$(cat /home/bitnami/bitnami_application_password) | sudo mysql -u dbmasteruser --host ls-abc123exampleE67890.czowadgeezqi.us-west-2.rds.amazonaws.com --password

I enter the password CORRECTLY and I get the following server reply:

ERROR 1045 (28000): Access denied for user 'dbmasteruser'@'17x.xx.xx.8x' (using password: YES) mysqldump: Got errno 32 on write

I am able to connect to the database via MySQL Workbench with no issues. I am running the commands via Direct SSH Terminal via Lightsail browser (Tried Putty as well). I also tried switch to an IAM account with the same result. Resources are all in same region and zone and I am using a static IP. Any suggestions?

Thank you in advance.

RMM
posta un anno fa94 visualizzazioni
Nessuna risposta

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande