Multiple databases

anyone know how I can get multiple databases on the same db host?
i have already created a databse under sql.mydomainname.com
but for this application im using, i need to create another database on the same host and dreamhost doesnt seem to allow me to do this. I even logged into my mysql databse and did
CREATE DATABASE databasename;
and it gave me a permission error…

anyone know if this can be done?

You’re only allowed one database per hostname.

You CAN create as many tables in that database as you want.

Try figuring out a prefix or suffix for the field names to differentiate what would be in one and what would be in another db.

Ex: “namexyz” and “nameabc”