Multiple mysql DBs, one virtual host name

Hi everyone. I was wondering if anyone could suggest strategies for management of multiple mysql databases under DH. I am now up to 20 or so and it is getting to be a pain with 20 different usernames and 20 different visrual host names. Does anyone have practical recommendations for consolidating all of the DBs under a single host name which, I am guessing, would also require some sort of trick in consolidating user names? Any other suggestions?

Thanks in advance.


no, it’s just a pain in the a** =) coming up with some really clever and obscure hostanme/usernames can be quite entertaining if you adjust your attitude a bit :wink: