Okay, I've convinced myself that this can't be done. In the http world, it can be done only because http/1.1 includes the hostname in the request. If mysql doesn't do that, there's no way to handle all the cases.
So I'll either have to settle for people remembering their own socket files, or ... I would settle for a single shared database in which users could create databases and drop their own databases but not other users'. They'll have to live with namespace collisions. Is that possible to do with mysql's permissions? Thanks. --Ryan On Thu, 20 Dec 2007 [EMAIL PROTECTED] wrote: > Hi. I'd like to set up something like apache's name-based virtual > hosting. > > I read the docs for mysqlmanager. It told me how to set it up to run > multiple instances of mysql on one machine, where each instance had its > own port number and socket file. > > I'd like to have my users connect to their own servers instead, and not > have to remember a port number. Like: > mysql -h mysql.username.domain.com -u username -p > > and then they'd be pointed at their appropriate instance. > > Anybody know how I can do that? > > Thanks. > --Ryan > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]