[TriLUG] two root users (was: Re: hello and mysql help please)

[jason watts]

yes, initial problem has been fixed.

i ended up uninstalling it, and then deleteing the folder with the database 
files i created... ended up being... or atleast apearing to be a completely 
fresh install

jsn

>From: Rob Wagner <robert.blick at duke.edu>
>Reply-To: Triangle Linux Users Group discussion list <trilug at trilug.org>
>To: trilug at trilug.org
>Subject: [TriLUG] two root users (was: Re: hello and mysql help please)
>Date: Sun, 18 Jun 2006 12:52:27 -0400
>
>A brief note - the reason MySQL installs two 'root' users is because of 
>unreliability (or inconsistency) with how the host reports its hostname.  
>You should have two root users: one with hostname = 'localhost' and the 
>other with hostname = 'some_hostname' (whatever your hostname really is).  
>MySQL differentiates the two; sometimes your client (whatever it may be) 
>may try to log in as root at localhost and other times it may be 
>root at some_hostname.  Furthermore, whenever you change root's password, make 
>sure you change both entries in the mysql.user table.
>
>Did you solve your initial problem?  Look up starting MySQL w/ 
>skip-grant-tables to replace a forgotten root password.
>
>Cheers!
>Rob
>
>Randall Barlow wrote:
>
>Date: Sat, 17 Jun 2006 16:12:07 -0400
>From: Randall Barlow <randall_barlow at ncsu.edu>
>Subject: Re: [TriLUG] hello and mysql help please
>To: Triangle Linux Users Group discussion list <trilug at trilug.org>
>Message-ID: <44946217.1020305 at ncsu.edu>
>Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
>jason watts wrote:
>
>> > in instructions say i should have four, root, snort, root, base... i > 
>>didnt think you could have 2 root users... didnt think you would be > able 
>>to have two user's in general with the same name...
>>
>With MySQL you can have two users of the same name from different hosts, 
>although I wouldn't recommend allowing root access from a remote host.  For 
>example, it's possible to have root at localhost as well as 
>root at someOtherHost.
>
>R
>
>--
>TriLUG mailing list        : http://www.trilug.org/mailman/listinfo/trilug
>TriLUG Organizational FAQ  : http://trilug.org/faq/
>TriLUG Member Services FAQ : http://members.trilug.org/services_faq/