troubleshooting Question

sql dump issue for Rds MYSQL in AWs

Avatar of A A
A A asked on
DatabasesRemote AccessAWSSQL
7 Comments3 Solutions19 ViewsLast Modified:
Hi experts
I have my sql and was trying to export database using sql dump command  from ec2 instance  to RDS MYSQL DATABSE  after enabling firewall between them  as  when running sql dump command I received this error

1-mysqldump: Got error: 1045: "Plugin sha256_password could not be loaded: /usr/lib/x86_64-linux-gnu/mariadb19/plugin/sha256_password.so: cannot open shared object file: No such file or directory" when trying to connect

2-Another thing how can I reset the password that I have it saved from old password managers  known that I have only access to console of both Rds and ec2 and only ssh to ec2

waiting for your advice regarding to fix no1,2 
ASKER CERTIFIED SOLUTION
David Favor
Fractional CTO
Join our community to see this answer!
Unlock 3 Answers and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros