Is this information exposed anywhere or am I going to have to write something
In particular I want the connection ID And Is the application at the source exposed And Can you trap the login event as a trigger yet? Kn -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gleb Paharenko Sent: 09 August 2005 11:02 To: mysql@lists.mysql.com Subject: Re: how to find out the name of the server Hello. You can determine the address of the server using 'status' command: mysql> status -------------- mysql Ver 14.7 Distrib 4.1.9, for pc-linux-gnu (i686) Connection id: 532284 Current database: Current user: [EMAIL PROTECTED] SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server version: 4.1.12-log Protocol version: 10 Connection: 10.100.1.176 via TCP/IP ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ Server characterset: cp1251 Db characterset: latin1 Client characterset: latin1 Conn. characterset: cp1251 TCP port: 3306 Uptime: 23 days 6 hours 27 min 59 sec suomi <[EMAIL PROTECTED]> wrote: > Hi every > > probably silliest question ever posted: > > we are running mysql on serveral hosts and sometime it is important to > know, which host is the mysql server you are connected to. > > this is not a session nor a global variable, there is no show statement... > > what is it else? how to ask a mysql client the name of the server you > are connected to? > > suomi > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- 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]
