Look around in the Cpanel and there should be an entry for managing databases. The root password is used for administering the database (creating tables, etc.) and many applications, like the ones that use PHP, will need it to function. You will probably be prompted to enter the database password when you do an installation.
