David, This is what I got:
[EMAIL PROTECTED]:~$ aliases bash: aliases: command not found [EMAIL PROTECTED]:~$ which mysql /usr/bin/mysql [EMAIL PROTECTED]:~$ $PATH bash: /usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/games: No such file or directory [EMAIL PROTECTED]:~$ 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' 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 > > +61 8 8408 4273 - Work > +61 417 268 665 - Mobile > +61 8 8408 4259 - Fax > > > -----Original Message----- > From: Mark Phillips [mailto:[EMAIL PROTECTED] > Sent: Thursday, 22 December 2005 5:21 PM > To: mysql@lists.mysql.com > 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 > > > > +61 8 8408 4273 - Work > > +61 417 268 665 - Mobile > > +61 8 8408 4259 - Fax > > > > > > -----Original Message----- > > From: Mark Phillips [mailto:[EMAIL PROTECTED] > > 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: > > > > [EMAIL PROTECTED]:~$ mysql -h localhost -u mark -p > > mysql: unknown option '--user mark' > > [EMAIL PROTECTED]:~$ > > > > If I su to another user, I can login as mark to mysql > > > > [EMAIL PROTECTED]:~$ 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 > > [EMAIL PROTECTED] > > 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/[EMAIL PROTECTED] -- 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]
