[EMAIL PROTECTED]
To: mysql@lists.mysql.com
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 mysql,
not the mysql client, so I'll have to see
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;
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 function that will return
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
Does anyone know a function
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
To: 'mysql@lists.mysql.com'
Subject: RE: host info
: 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
To: 'mysql@lists.mysql.com'
Subject: RE: host
[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
-Original Message-
From: Berman, Mikhail [mailto
@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
:[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
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
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 method i can see is : ls datadir_path/*.pid
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
12 matches
Mail list logo