Re: host info

2005-04-28 Thread Eamon Daly
essage - From: "Stanton, Brian" <[EMAIL PROTECTED]> To: Sent: Wednesday, April 27, 2005 2:07 PM Subject: RE: host info The 'Connection' output from the 'status' command is actually what I was looking for. However, most likely it will be a jdbc connection to m

RE: host info

2005-04-27 Thread mathias fatene
That's it:o) Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -Original Message- From: Stanton, Brian [mailto:[EMAIL PROTECTED] Sent: mercredi 27 avril 2005 23:12 To: 'mysql@lists.mysql.com' Subject

RE: host info

2005-04-27 Thread Stanton, Brian
27, 2005 3:42 PM To: Stanton, Brian Cc: 'mysql@lists.mysql.com' Subject: RE: host info Hi all, Mysql server knows the OS server as localhost. the hostname you see in status is the OS server from which you connect (the client one), since it's defined in the grant. The only

RE: host info

2005-04-27 Thread mfatene
y 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

RE: host info

2005-04-27 Thread Stanton, Brian
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 &#

Re: host info

2005-04-27 Thread Eamon Daly
Stanton, Brian" <[EMAIL PROTECTED]> To: 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

RE: host info

2005-04-27 Thread Berman, Mikhail
iginal Message- From: Stanton, Brian [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005 2:10 PM To: 'mysql@lists.mysql.com' Subject: RE: host info Using 4.0.18... connected from one unix box to another using mysql -h server -u user -p database Thanks, Brian Stanton -

RE: host info

2005-04-27 Thread Stanton, Brian
: host info Brian, Have you initiated "mysql" command with "-h host-name" option or just "mysql" with other options but "-h"? Mikhail Berman -Original Message- From: Stanton, Brian [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005 11:33 AM

RE: host info

2005-04-27 Thread Berman, Mikhail
, 2005 10:28 AM To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: RE: host info Brian, In UNIX from "mysql" prompt do: mysql> system /bin/hostname Mikhail -Original Message- From: Stanton, Brian [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005 11:03 AM To: &#x

RE: host info

2005-04-27 Thread Stanton, Brian
.mysql.com Subject: RE: host info Brian, In UNIX from "mysql" prompt do: mysql> system /bin/hostname Mikhail -Original Message- From: Stanton, Brian [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005 11:03 AM To: 'mysql@lists.mysql.com' Subject: host info

RE: host info

2005-04-27 Thread Berman, Mikhail
Brian, In UNIX from "mysql" prompt do: mysql> system /bin/hostname Mikhail -Original Message- From: Stanton, Brian [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005 11:03 AM To: 'mysql@lists.mysql.com' Subject: host info Does anyone know a functi

host info

2005-04-27 Thread Stanton, Brian
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;