I am configuring mysql for my server, but I have one question: Is it possible for each domain to see their own mysql server, but only having to run one service at the server? I want to keep all databases for the domains separated, but I don't want to have to prefix each database name.
eg: suppose I have domain1.com and a domain2.com running on the same server. For both domains I want a database called statistics. If I want to do this now, I'll have to prefix the databases, so there are two databases: domain1_statistics and domain2_statistics, and the domains can only access their own databases. But I want to create 2 databases called statistics, one for each domain, so that each domain only sees its own statistics database. Is this possible?