Two roots?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Richard Hollenbeck
    #1

    Two roots?

    I'm sure there's a good explanation, but I haven't seen it in any of the
    documentation. When I query the mysql database in the user table I see
    two roots--one with the host as "localhost" and the other with the host as
    "linux.site ." I suppose this is normal, but I don't understand why.
    This is sort of a repost from yesterday, but since then I reinstalled
    linux from scratch (SUSE 9.2 pro) I haven't yet added any users or set any
    passwords--I haven't yet done anything to screw-up this pristine install.
    Is it normal to see two roots in this kind of query? Last time I went in
    as root and really messed things up. here's my second chance.

    mysql>SELECT user, host, password FROM user;
    +------+------------+----------+
    | user | host | password |
    +------+------------+----------+
    | root | localhost | |
    | root | linux.site | |
    | | localhost | |
    | | linux.site | |
    +------+------------+----------+
    4 rows in set (0.00 sec)

    mysql>


    Which root is the "real" root? Should I delete the anonymous users? Do
    I need at least one limited guest account for my soon-to-be-written PHP
    pages? Please advise.

    Thanks.

    Rich Hollenbeck

    Tags: None
    • Oscar A. Moreno
      #2
      Re: Two roots?

      It's all explained in p. 130 of the LATEST MySQL Reference Manual.
      Oscar


      On 11/25/04 09:55, in article pan.2004.11.25. 06.55.37.926867 @verizon.net,
      "Richard Hollenbeck" <richard.hollen beck@verizon.ne t> wrote:
      [color=blue]
      > I'm sure there's a good explanation, but I haven't seen it in any of the
      > documentation. When I query the mysql database in the user table I see
      > two roots--one with the host as "localhost" and the other with the host as
      > "linux.site ." I suppose this is normal, but I don't understand why.
      > This is sort of a repost from yesterday, but since then I reinstalled
      > linux from scratch (SUSE 9.2 pro) I haven't yet added any users or set any
      > passwords--I haven't yet done anything to screw-up this pristine install.
      > Is it normal to see two roots in this kind of query? Last time I went in
      > as root and really messed things up. here's my second chance.
      >
      > mysql>SELECT user, host, password FROM user;
      > +------+------------+----------+
      > | user | host | password |
      > +------+------------+----------+
      > | root | localhost | |
      > | root | linux.site | |
      > | | localhost | |
      > | | linux.site | |
      > +------+------------+----------+
      > 4 rows in set (0.00 sec)
      >
      > mysql>
      >
      >
      > Which root is the "real" root? Should I delete the anonymous users? Do
      > I need at least one limited guest account for my soon-to-be-written PHP
      > pages? Please advise.
      >
      > Thanks.
      >
      > Rich Hollenbeck
      >[/color]

        Comment

        • Richard Hollenbeck
          #3
          Re: Two roots?

          On Thu, 25 Nov 2004 15:31:56 +0000, Oscar A. Moreno wrote:[color=blue]
          > It's all explained in p. 130 of the LATEST MySQL Reference Manual.
          > Oscar[/color]

          Thank you Oscar,

          I don't actually have that book. Fortunately, I found an online version
          at http://dev.mysql.com/doc/mysql/en/De...rivileges.html which may
          roughly equate to page 130. Anyway, you're right; it seems to be exactly
          the kind of information I was looking for. Now that I know where to go,
          for this kind of information in the future, I should be up to speed much
          more quickly. I really should buy the paper version of it. Thanks again.

          Rich

            Comment

            • Oscar A. Moreno
              #4
              Re: Two roots?

              To get the latest and greatest of the Reference Manual, go to
              http://dev.mysql.com/get/Downloads/M....pdf/from/pick and select
              the mirror closest to your heart and download it to your HD. No need to
              spend moollah!!. This is a PDF format.

              Oscar


              On 11/26/04 00:42, in article pan.2004.11.25. 21.42.42.43208@ verizon.net,
              "Richard Hollenbeck" <richard.hollen beck@verizon.ne t> wrote:
              [color=blue]
              > On Thu, 25 Nov 2004 15:31:56 +0000, Oscar A. Moreno wrote:[color=green]
              >> It's all explained in p. 130 of the LATEST MySQL Reference Manual.
              >> Oscar[/color]
              >
              > Thank you Oscar,
              >
              > I don't actually have that book. Fortunately, I found an online version
              > at http://dev.mysql.com/doc/mysql/en/De...rivileges.html which may
              > roughly equate to page 130. Anyway, you're right; it seems to be exactly
              > the kind of information I was looking for. Now that I know where to go,
              > for this kind of information in the future, I should be up to speed much
              > more quickly. I really should buy the paper version of it. Thanks again.
              >
              > Rich
              >[/color]

                Comment

                Previous template Next
                Working...