Hi maybeme and welcome to the forum
When you create a new MySQL database in the DreamHost panel, you have the option of using an existing database user or creating a completely new user for this database. Basically, whether you use the one database user for all your databases or create a new user for each database is totally up to you. You can of-course edit a specific database user's privileges (select, insert, update etc.) via the panel.
There is no real 'demo' of the control panel, but you can use the link below to obtain a DreamHost account without buying any hosting. However, you wont actually be able to do much without an active hosting plan under the account.
Save [color=#CC0000]$50[/color] on all DreamHost plans using [color=#CC0000]PRICESLASH[/color] promo code (Click for DreamHost Review)