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

[Rob Wagner]

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