RE: Need Help Connecting

[David (SST - Adelaide) Logan]

What happens when you type

$ /usr/bin/mysql -h localhost -u mark -p 

Does this work? I'm off home now so won't be able to check your reply
for about 2 hours.

Regards

David Logan 
Database Administrator 
HP Managed Services 
148 Frome Street, 
Adelaide 5000 
Australia 

[phone] - Work 
[phone] - Mobile 
[phone] - Fax 


-----Original Message-----
From: Mark Phillips [mailto:mark@stripped] 
Sent: Thursday, 22 December 2005 5:36 PM
To: Logan, David (SST - Adelaide)
Cc: mysql@stripped
Subject: Re: Need Help Connecting

David,

This is what I got:

mark@latitude610:~$ aliases
bash: aliases: command not found

mark@latitude610:~$ which mysql
/usr/bin/mysql

mark@latitude610:~$ $PATH
bash: /usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/games: No such file
or 
directory
mark@latitude610:~$      

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'

Thanks!

Mark  
On Wednesday 21 December 2005 11:55 pm, Logan, David (SST - Adelaide)
wrote:
> Try typing at the command prompt
>
> $ aliases
>
> $ which mysql
>
> $ echo $PATH
>
> The first one will list any aliases that have been setup. The second
> will tell you the directory the system thinks it is getting mysql from
> and the third will list your PATH environment variable. If you see an
> alias named mysql, that may well be your culprit. If you installed
from
> an rpm (I don't know much about the debian apt-get thingy) you should
> find the mysql command in /usr/bin
>
> Regards
>
> David Logan
> Database Administrator
> HP Managed Services
> 148 Frome Street,
> Adelaide 5000
> Australia
>
> [phone] - Work
> [phone] - Mobile
> [phone] - Fax
>
>
> -----Original Message-----
> From: Mark Phillips [mailto:mark@stripped]
> Sent: Thursday, 22 December 2005 5:21 PM
> To: mysql@stripped
> Cc: Logan, David (SST - Adelaide)
> Subject: Re: Need Help Connecting
>
> David,
>
> How do I do that?
>
> Thanks!
>
> Mark
>
> On Wednesday 21 December 2005 11:37 pm, Logan, David (SST - Adelaide)
>
> wrote:
> > Hi Mark,
> >
> > Have you checked to see if you any aliases set? It might be using
that
> > instead of the mysql command. May well be worth checking your path
to
> > ensure you aren't picking up a script called mysql or something
>
> similar.
>
> > Regards
> >
> >
> > David Logan
> > Database Administrator
> > HP Managed Services
> > 148 Frome Street,
> > Adelaide 5000
> > Australia
> >
> > [phone] - Work
> > [phone] - Mobile
> > [phone] - Fax
> >
> >
> > -----Original Message-----
> > From: Mark Phillips [mailto:mark@stripped]
> > Sent: Thursday, 22 December 2005 5:02 PM
> > To: MYSQL List
> > Subject: Need Help Connecting
> >
> > I have the following setup - mysql 4.0.24 running on Debian Linux
> > stable.
> >
> > I set up a user 'mark' with a password. When I log into my Linux box
>
> as
>
> > user
> > 'mark', I cannot connect to mysql - I get this funny error message:
> >
> > mark@latitude610:~$ mysql -h localhost -u mark -p
> > mysql: unknown option '--user           mark'
> > mark@latitude610:~$
> >
> > If I su to another user, I can login as mark to mysql
> >
> > emily@latitude610:~$ mysql -h localhost -u mark -p
> > Enter password:
> > Welcome to the MySQL monitor.  Commands end with ; or \g.
> > Your MySQL connection id is 128 to server version:
> > 4.0.24_Debian-10sarge1-log
> >
> > Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> >
> > mysql>
> >
> > I don't get it - why can't I use the '-u mark' option with mysql
when
>
> I
>
> > am
> > logged into my own Linux user account?
> >
> > Thanks!
> > --
> > Mark Phillips
> > Phillips Marketing, Inc
> > mark@stripped
> > 602 524-0376
> > 480 945-9197 fax
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
>
> http://lists.mysql.com/mysql?unsub=1

-- 
Mark Phillips
mark@stripped
602 524-0376