i have written a web app at www.weemfg.com using sqlite that supports multiple clients each with their own database. i am migrating it to mysql and i am faced with identifying my users by placing their ‘clynt’ name in every row of every table. I would like to be able to point each of my clynts to their own database like ‘weemfgdb.harry’ and ‘weemfgdb.mary’. my web host will supply me with the mysql database ‘weemfgdb’ and i would create my own sub-database ‘harry’. i cant find any web reference that tells me how to do that so i am asking here.

i have not tried anything. i am asking how.