Brian,
Thursday, October 31, 2002, 6:07:43 PM, you wrote:

BH> Is there anyway to get a mysql server to tell me

BH> a) What user I am connected as?
BH> b) What host I am connected from (i.e., localhost vs. fqdn)?

SELECT USER();

BH> c) What database I am using?

SELECT DATABASE();

SHOW PROCESSLIST also may help you.

BH> The reason for the question is that I want to print diagnostics in scripts 
BH> that don't contain connection information (it is hidden in configuration 
BH> files parsed by library code).

BH> So mysql_access, database 'use' or 'select' statements, or looking at 
BH> script dbh parameters don't help.



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com




---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to