I took help from this article link to move my database to be stored in EBS volume, I mounted the volume and did all those steps. I rebooted my instance and when i tried again it says connection refused. I had to follow these steps link to edit my fstab file(not the files mentioned in the link, they were all fine). I had to deleted all the mount sql lines:
mount /etc/mysql
mount /var/lib/mysql
mount /var/lib/mysql
and after again reattaching the EBS to my original instance i could login to it. So my question is did i do something wrong or what do i need to do to make my mysql Database be stored in the EBS and not on the instance. I don't wanna take a risk again editing fstab.