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]
