troubleshooting Question

sql dump issue for Rds MYSQL in AWs

Avatar of A A
A A asked on
Remote AccessSQLDatabasesAWS
7 Comments3 Solutions22 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
Log in to continue reading
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform for $9.99/mo
View membership options
Unlock 3 Answers and 7 Comments.
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
The Value of Experts Exchange in My Daily IT Life

Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>

Mike

Owner of Outages.IO
Phoenix, Arizona, United States
Member Since 2016
Join a full scale community that combines the best parts of other tools into one platform.
Unlock 3 Answers and 7 Comments.
View membership options
“All of life is about relationships, and EE has made a virtual community a real community. It lifts everyone's boat.”
William Peck

Member since 2004