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
I am less than 24 hours new to MySql. I have executed the following sql
scripts:
use mysql;
delete from user where User='';
delete from db where User='';
flush privileges;
select host, user, password from user;
The last sql query yields the following:
hostuserpassword
Station 32003
Atlanta GA 30332
Cell: +404.429.5513
http://www.arjunweb.com
-Original Message-
From: Leo Donahue [mailto:[EMAIL PROTECTED]
Sent: Friday, January 09, 2004 2:47 PM
To: [EMAIL PROTECTED]
Subject: mysql database, user table, two root accounts
I am less than 24 hours new to MySql
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