[TriLUG] two root users (was: Re: hello and mysql help please)
robert.blick at duke.edu
Sun Jun 18 12:52:27 EDT 2006
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.
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.
More information about the TriLUG