How can I retrieve my database password. I've forgotten it and I was wondering is there a possible way to locate it? I have the username luckily. Thanks
From Cpanel the easiest thing to do would be to create a new user with a password that you won't forget and then add it to the database. Once the new user is working you can delete the one you don't know the password for.
If you have access to Cpanel you probably have access to FTP, if not set yourself up with a FTP account and use the FTP program to access all your files, in the folder for the site associated with the DB you should have a config.php file, inside that file you will have your database address, username and password.
if you know the username and have access using SSH use: passwd <username> Code (markup): and then enter the new password