setting up mysql for multiple sites

[supermanjnk]

I was wondering, how would i go about setting up different sites in mysql? for instance site one can have 5 mysql databases, one of those is forum

site two also has 5 mysql databases of which one is also forum,
obviously i can't have to databases with the same name.

as of right now regardless of which site I access phpmyadmin with it will show all the databases and tables.

do i need to set something in sql?

[txbakers]

in Your connection string you specify which database to connect to. You can also specify the database in the query as follows:

select database.table.field from database.table, etc.