connecting to rds mariadb or any database through ec2

mysql -h -P 3306 -u <username_defined_in_rds> -p

-- after hitting this command we need to enter the password we specified in the rds creation !!

-- we can connect without specifying databse name here by that we will only be connecting with the rds database server

mysql -h insert-your-database-name.abcdefgh.us-east-1.rds.amazonaws.com -P 3306 -u admin -p

Migration of Database in EC2 Instance to RDS Database:

mysqldump -u -p > <database_name>.sql

mysqldump -u root -p ec2db > ec2db.sql

here we are dumping (storing ) our database into .sql which we will be sending to rds

mysql -h -P 3306 -u -p < ec2db.sql

using this our data has been dumped to rds

mysql -h -P 3306 -u rdsuser -p

connecting to the rds database

USE rdsdb SELECT * FROM table1;