Here are the results of alias and type
mark@latitude610:~$ alias
alias ls='ls --color=auto'
mark@latitude610:~$ type mysql
mysql is /usr/bin/mysql
And for the emily account:
emily@latitude610:/home/mark$ alias
alias ls='ls --color=auto'
emily@latitude610:/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
emily@latitude610:/home/mark$ $PATH
bash: /usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/games: No such file or
directory
emily@latitude610:/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:
> >
> > mark@latitude610:~$ aliases
> > bash: aliases: command not found
>
> Your shell is bash, so the correct command is `alias`.
>
> > mark@latitude610:~$ 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
>
> > mark@latitude610:~$ $PATH
> > bash: /usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/games: No such file
> > or directory
> > mark@latitude610:~$
>
> 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:
> >
> > emily@latitude610:/home/mark$ which mysql
> > /usr/bin/mysql
> >
> > emily@latitude610:/home/mark$ echo $PATH
> > /usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/games
> > emily@latitude610:/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
mark@stripped
602 524-0376
