Professional Web Applications Themes

Mysql variable: Hostname of CLIENT - MySQL

Looking to write a script such as: select * from domains where hostname=MYSQL.CLIENT.HOSTNAME that dynamically matches against the hostname (or at least IP) of the connecting server and returns the appropriate matching rows. Is this possible? Thanks, Daniel...

  1. #1

    Default Mysql variable: Hostname of CLIENT

    Looking to write a script such as:

    select * from domains where hostname=MYSQL.CLIENT.HOSTNAME

    that dynamically matches against the hostname (or at least IP) of the
    connecting server and returns the appropriate matching rows.

    Is this possible?
    Thanks,
    Daniel

    danson Guest

  2. #2

    Default Re: Mysql variable: Hostname of CLIENT

    "danson" <danwatts> wrote:
    > Looking to write a script such as:
    >
    > select * from domains where hostname=MYSQL.CLIENT.HOSTNAME
    >
    > that dynamically matches against the hostname (or at least IP) of the
    > connecting server and returns the appropriate matching rows.
    >
    > Is this possible?
    SELECT USER()

    shows you what user and host was used to establish your current
    connection to the database. So the host part is

    SELECT SUBSTRING_INDEX(USER(), '', -1)

    By default mysqld tries to lookup IP numbers but you may configure
    either mysqld or your hostsystem to not use reverse lookups. Then
    you will get a numerical host address.


    XL
    --
    Axel Schwenke, Senior Software Developer, MySQL AB

    Online User Manual: [url]http://dev.mysql.com/doc/refman/5.0/en/[/url]
    MySQL User Forums: [url]http://forums.mysql.com/[/url]
    Axel Schwenke Guest

  3. #3

    Default Re: Mysql variable: Hostname of CLIENT


    Axel Schwenke wrote:
    > "danson" <danwatts> wrote:
    > > Looking to write a script such as:
    > >
    > > select * from domains where hostname=MYSQL.CLIENT.HOSTNAME
    > >
    > > that dynamically matches against the hostname (or at least IP) of the
    > > connecting server and returns the appropriate matching rows.
    > >
    > > Is this possible?
    >
    > SELECT USER()
    >
    > shows you what user and host was used to establish your current
    > connection to the database. So the host part is
    >
    > SELECT SUBSTRING_INDEX(USER(), '', -1)
    >
    > By default mysqld tries to lookup IP numbers but you may configure
    > either mysqld or your hostsystem to not use reverse lookups. Then
    > you will get a numerical host address.
    >
    >
    > XL
    > --
    > Axel Schwenke, Senior Software Developer, MySQL AB
    >
    > Online User Manual: [url]http://dev.mysql.com/doc/refman/5.0/en/[/url]
    > MySQL User Forums: [url]http://forums.mysql.com/[/url]
    this is really good thank you very much for replying!

    danson Guest

Similar Threads

  1. Replies: 2
    Last Post: April 28th, 10:11 PM
  2. Problem with client variable
    By lg2 in forum Coldfusion - Getting Started
    Replies: 0
    Last Post: October 5th, 03:06 AM
  3. MySQL and PGSQL and Hostname Question
    By Jeff Skeith in forum PHP Development
    Replies: 2
    Last Post: September 14th, 10:47 PM
  4. Identify dhcp client to server using hostname
    By Robert Ian Smit in forum Debian
    Replies: 1
    Last Post: July 30th, 06:20 PM
  5. Replies: 0
    Last Post: July 7th, 07:42 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139