|List:||General Discussion||« Previous MessageNext Message »|
|From:||Paul DuBois||Date:||September 24 1999 7:00pm|
|Subject:||Re: "ERROR 2002" or "I promise I'm not just stupid." or "whywould|
mysql care who i'm logged in as?"
|View as plain text|
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