Mysql Server Name

[phpprogrammer]

Dear Friends,

If I connected to a Mysql server and selected a database then

how can we find the name of that connected Mysql server

we are having the statement select database() --- to find the working database

is there any command to find the name of the server/ ip of the server where the database is hosted

regards
bvsureshbabu

[weekender]

surely if you have connected to the mysql server, then you have connected using either a hostname or an ip address.

if you have the hostname, get the ip using [man]gethostbyname[/man]

if you have the ip, get the hostname using [man]gethostbyaddr[/man]

adam