Two roots?

[Richard Hollenbeck]

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

[Oscar A. Moreno]

It's all explained in p. 130 of the LATEST MySQL Reference Manual.
Oscar
On 11/25/04 09:55, in article pa****************************@verizon.net,
"Richard Hollenbeck" <ri****************@verizon.net> wrote:

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

[Richard Hollenbeck]

On Thu, 25 Nov 2004 15:31:56 +0000, Oscar A. Moreno wrote:

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

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

[Oscar A. Moreno]

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 pa***************************@verizon.net,
"Richard Hollenbeck" <ri****************@verizon.net> wrote:

On Thu, 25 Nov 2004 15:31:56 +0000, Oscar A. Moreno wrote:

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

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