Re: "ERROR 2002" or "I promise I'm not just stupid." or "whywould mysql care who i'm logged in as?"

[Paul DuBois]

At 1:59 PM -0500 9/24/99, nathaniel c. daiger wrote:
>>>why in god's name would mysql care what user i'm logged in as?
>>
>>Because your default MySQL user name if you don't specify one is your
>>UNIX login name.  It sounds like you're not specifying a user name when
>>you run mysql.
>>
>
>sorry, i didn't make that clear...
>
>example:
>
>[nate@host] $ mysql -p
>Enter password: ********
>ERROR: 2002 Can't connect blah blah
>
>[nate@host] $ sudo tcsh
>[root@host] # mysql -u nate -p
>Enter password: ********
>
>Welcome to MySQL. Despite being generally great, I'm acting dumb today.

Nate the Great, huh?  Perhaps you haven't had enough pancakes yet today. :-)


Well, lessee.  Yes, it looks like you should be able to connect with that
first command.  Do you have a ~/.my.cnf file that's specifying some
other user name, by chance?

--
Paul DuBois, paul@stripped