Here are the results of alias and type [EMAIL PROTECTED]:~$ alias alias ls='ls --color=auto'
[EMAIL PROTECTED]:~$ type mysql mysql is /usr/bin/mysql And for the emily account: [EMAIL PROTECTED]:/home/mark$ alias alias ls='ls --color=auto' [EMAIL PROTECTED]:/home/mark$ type mysql mysql is /usr/bin/mysql The error from my PATH is from how I used it. I left out the 'echo' command. I get the same results in the emily account [EMAIL PROTECTED]:/home/mark$ $PATH bash: /usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/games: No such file or directory [EMAIL PROTECTED]:/home/mark$ echo $PATH /usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/games However, Michael hit the nail on the head! I have a .my.cnf file that was causing the problem. I had the line user mark which should be user=mark That also explains the funny error message I was getting. Thanks for all your help, everything is now working!! Mark On Thursday 22 December 2005 06:28 am, Michael Stassen wrote: > Mark Phillips wrote: > > David, > > > > This is what I got: > > > > [EMAIL PROTECTED]:~$ aliases > > bash: aliases: command not found > > Your shell is bash, so the correct command is `alias`. > > > [EMAIL PROTECTED]:~$ which mysql > > /usr/bin/mysql > > Since you are using bash, it's a better idea to use `type` instead of > `which`. On some systems (Solaris 7, for example), `which` can give bogus > results in bash. So, try > > type mysql > > > [EMAIL PROTECTED]:~$ $PATH > > bash: /usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/games: No such file > > or directory > > [EMAIL PROTECTED]:~$ > > Something is wrong with mark's PATH. See the error at the end? > > > I don't have a command 'aliases', but the other tests seem to say all I > > have is mysql running as mysql. > > > > When I am logged in as 'emily' I get: > > > > [EMAIL PROTECTED]:/home/mark$ which mysql > > /usr/bin/mysql > > > > [EMAIL PROTECTED]:/home/mark$ echo $PATH > > /usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/games > > [EMAIL PROTECTED]:/home/mark$ > > > > Any other thoughts? The error message from mysql when I try to log in is > > strange. Why all the spaces? > > > > mysql: unknown option '--user mark' > > I don't believe that error came from mysql. Indeed, mysql doesn't care > which unix user runs it, it only cares which mysql user you say you are. > Because it works as expected when Emily runs it, I don't believe mysql is > the problem. I believe David is correct that there is something in mark's > environment that is causing the problem. Check the output of `alias` and > `type mysql`, and check mark's .my.cnf file, if he has one. > > > Thanks! > > > > Mark > > Michael -- Mark Phillips [EMAIL PROTECTED] 602 524-0376 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]