The 'Connection' output from the 'status' command is actually what I was looking for. However, most likely it will be a jdbc connection to mysql, not the mysql client, so I'll have to see if it works that way or not.
Thanks, Brian Stanton -----Original Message----- From: Eamon Daly [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005 2:04 PM To: Stanton, Brian; mysql@lists.mysql.com Subject: Re: host info I don't know if it's possible in MySQL. That said, in the mysql client, you can type '\s' for 'status'. Look for 'Current user' in the output. ____________________________________________________________ Eamon Daly ----- Original Message ----- From: "Stanton, Brian" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Sent: Wednesday, April 27, 2005 10:03 AM Subject: host info > Does anyone know a function that will return the hostname of the mysql > server you are connecting to? > > > > Just as: > > mysql> select database(); > > returns the database you're connected to, I need to display the host I'm > connected to. > > > > Similar to the oracle statement: select host_name from v$instance; > > > > Thanks, > > Brian Stanton -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
