Okay, I just found out what I was doing wrong. Having looked in the docs,
but I'm sure this is documented behavior.
> MySQL 4.0.12, MSW2k. Here's what's puzzling me --
>
> I set up a new user yesterday. I'm pretty sure I was able to connect as
> the user from the command line yesterday, before I shut my machine down
> and went home. I can't today.
>
> I have this user entry in my mysql.user table:
>
> | localhost | fromWeb | <scrambled-password> | N | ...
^^^^^^^ This was the evil beast.
Apparently, user names can't have capitals in them and be accessed from
the command line, even though they can be accessed that way from php's
library. I'm assuming there's something in the command line interface
which forces the user name to lower case.
So I changed the user name to 'fromweb' in mysql.user and mysql.db, and
now I have no problems.
But I still wonder about this:
> It complains
>
> "ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using
> password: YES)".
>
> ...
> Second, why does it complain about the loopback when I said localhost on
> the command line? Could this have something to do with named pipes?
Is localhost folded to the loopback? That seems it might be a little
awkward.
--
Joel Rees <[EMAIL PROTECTED]>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
