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 <[EMAIL PROTECTED]>
Reply-To: Triangle Linux Users Group discussion list <[email protected]>
To: [email protected]
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 [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/
--
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/
