Yes we can recover password of a user on WordPress incase he donot have the Email address used to sign up on the wordpress. Here is a way to get it.

Requirements:
1. Should have Database Access
2. Have the FTP of the wordpress

Procedure:
So, you have a the DB access. Explore the DB in PHPMYADMIN interface. (You can find PHPMYADMIN link in CPANEL). Now login to your FTP of the site and Open the wp-config.php file present in root folder of WordPress installation. Find the Database name used for tht wordpress installation.. Got it. Cool. Now Switch to PHPMYADMIN and explore tht particular DB. Then Explore: “wp_users” table. Then click on “BROWSE” to show the data present in it.
Yes now you are looking at all the list of the Users on your wordpress site. Now click the small edit icon beside the User Entry for which you want to change the “user_pass” filed. Then select funtion “DB5” from the drop down. Then type in the new password you wanna set up (e.g. password ) and click on GO.

You are done! Cheers! Now you can login using your new login details.

Do let me know any issues doing the steps i mentioned. I will be happy to answer you.