working out my hostname (is this a stupid question?)

**chrisdb** · Jun 20, 2005 04:50

probably

How can I work out the hostname of my server. For local scripts i can just use 'localhost', but not for my remote script. Is the hostname based on my URL?

Also, will hosts generally allow scripts to access/ modify local databases, or will they normally not allow this?

**Chagh** · Jun 20, 2005 05:10

hi chrisdb
you can do this by

Code:

select * from mysql.users

if you have permission to access it or by

Code:

reverse(substring_index(reverse(current_user()),_utf8'@',1))

Chagh

**chrisdb** · Jun 21, 2005 02:15

Cheers chagh, but neither of those work. (First no permission, second generates error). Was the second one for MySQL or PHP?

For this software im using i need the hostname and port number for my MySQL db. Can this information be derived from what is returned by running phpinfo()?

**Chagh** · Jun 21, 2005 03:28

I don't know about phpinfo but that function is for MySQL,
you should "select reverse..."
does it gives you an error when you use it in a select statement?

Chagh

**chrisdb** · Jun 21, 2005 03:31

i get:

SQL-query: Documentation

SELECT reverse( substring_index( reverse( current_user( ) ) , _utf8 '@', 1 ) )

MySQL said: Documentation
#1064 - You have an error in your SQL syntax near '()),_utf8'@',1))' at line 1

**Chagh** · Jun 21, 2005 03:42

which version of mysql do you use?
CURRENT_USER() was added in MySQL 4.0.6. As of MySQL 4.1, the string has the utf8 character set.
you can use USER() instead of current_user ,As of MySQL 4.1, USER() returns a value in the utf8 character set, so you should also make sure that the '@' string literal is interpreted in that character set.

Chagh

**chrisdb** · Jun 21, 2005 03:51

Ah, yes. See my other post "update if present else insert", i figured out today I'm on MySQL 3.23. Sorry for not mentioning it sooner.

This sucks! I need to get my host to sort this out. Nothing anybody suggests works! How old is 3.23 now?