Once you've setup a MySQL database using MySQL Manager you should then have your MySQL details. You'll usually require the below 4 details to connect your website to your database.
MySQL (database) hostname (or server)
Listed under DB Host in MySQL Manager (e.g. sql5c30a.carrierzone.com).
MySQL (database) username
Listed under User Name in MySQL Manager (e.g. yourdomain123456).
MySQL (database) password
This cannot be viewed only reset. Note if you reset the password on an existing site your site may not function until you update the configuration files with the new password.
MySQL database name
Listed under Available Databases, make sure the database is next to the MySQL username you chose earlier.