Re: Need Help Connecting

[Michael Stassen]

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