Paul DuBois [EMAIL PROTECTED] wrote: > At 12:30 -0500 8/22/03, [EMAIL PROTECTED] wrote: > >------------------------------------------------ > >On Fri, 22 Aug 2003 12:43:47 -0400, Hardy Merrill <[EMAIL PROTECTED]> > >wrote: > > > >> I know this is off-topic, but am hoping one of you who > >> knows MySQL well will be able to answer this quickly, > >> as I haven't been able to find the answer in books or > >> on the internet. > >> > >> Is there a mysql command that I can issue at the 'mysql>' > >> client prompt that will tell me the hostname of the > >> machine on which the MySQL database (server) is running? > >> > > > >'status', it provides more than you requested don't know if there is > >a way to limit it. See the 'Connection' property... > > Actually, the answer is "no". "Connection" in the status message may > indicate a value that, while correct, is not useful as a host name. > (Try connecting over a named pipe to Windows server and check the status > message, for example.)
I noticed this myself. What prompted my question is that I'm setting up MySQL as a cluster service - I need a way to prove *which* host is running the mysql service, but so far I'm not aware of any command I can give mysql that will tell me the host it's running on. Thanks for the input, and sorry for OT. -- Hardy Merrill Red Hat, Inc.
