Is it true that each mysql database on DreamHost must have a unique user? I can't have two MySQL databases with one user?
Yes, that's true. One database per hostname, one uniquie user for each database. It may seem a little frustrating when you are getting started, but it's not really an issue.