You can't login as plain old nobody.
The default mysql user is your unix user, so if you are
logged into unix as root , and entered mysql you were logged into
mysql as root.
You appear to have been logged in as mysql.
If the user mysql has full privileges, then there was nothing to
prevent the
However, you are running WIN2K, not unix as i assumed in my previous post.
There still must be some default user which apparently has full privileges.
Bryan Capitano wrote:
Having some problems setting root password on MySQL. Can anybody help
me?
I've just installed MySQL 3.23.38 on a Windows
Gerald...
He isn't on a Unix box, he is on a Win2k box
-Original Message-
From: Gerald Clark [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 10, 2002 8:46 AM
To: Bryan Capitano
Cc: [EMAIL PROTECTED]
Subject: Re: setting root psswd on Win2K ??
You can't login as plain old nobody
Yes, thank you, everybody's comments have been helpful.
It seems, as Roel has noted, that the user where user='' and host='localhost'
has all kinds of
privileges. Which explains why when I log in as simply 'mysql' without
specifying a particular
user, than I have omnipotent powers.
delete from