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 [EMAIL PROTECTED] and other times it may be [EMAIL PROTECTED]
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 <[EMAIL PROTECTED]>
Subject: Re: [TriLUG] hello and mysql help please
To: Triangle Linux Users Group discussion list <[email protected]>
Message-ID: <[EMAIL PROTECTED]>
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 [EMAIL PROTECTED] as well as
[EMAIL PROTECTED]
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/
