On 9 Jan 2004, at 22:43, Michael Stassen wrote:
As [EMAIL PROTECTED] and [EMAIL PROTECTED] are separate entries in the user table,
each with its own password and privileges, they are 2 separate root
accounts from mysql's perspective. You could choose to think of them
as the same
Steve Folly wrote:
On 9 Jan 2004, at 22:43, Michael Stassen wrote:
As [EMAIL PROTECTED] and [EMAIL PROTECTED] are separate entries in the user table,
each with its own password and privileges, they are 2 separate root
accounts from mysql's perspective. You could choose to think of them
as
On 10 Jan 2004, at 17:47, Michael Stassen wrote:
Eg. if you've two host entries; one '192.%' and the other '192.168.%'
- and you connect from 192.168.100.12, which row gets chosen?
As I understand it, 192.168.% is more specific than 192.%, so
192.168.100.12 would match 192.168.%
My thoughts
That's not two root accounts. What that means is this:
The first line defines privileges for root connecting from localhost
The second line defines privileges for root connecting from any remote
host. Hence the %. It implies [EMAIL PROTECTED]
Hope this helps.
Arjun Subramanian
Georgia Tech
Yes, this helps thank you.
-Original Message-
From: Arjun Subramanian [mailto:[EMAIL PROTECTED]
Sent: Friday, January 09, 2004 2:16 PM
To: 'Leo Donahue'; [EMAIL PROTECTED]
Subject: RE: mysql database, user table, two root accounts
That's not two root accounts. What that means
, 2004 2:16 PM
To: 'Leo Donahue'; [EMAIL PROTECTED]
Subject: RE: mysql database, user table, two root accounts
That's not two root accounts. What that means is this:
The first line defines privileges for root connecting from localhost
The second line defines privileges for root connecting from any