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
asked a year ago92 views
No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions