Parker & Mike: Thank you so much. I changed the profile according to what you guys told me, and add "/usr/local/mysql/bin" to the profile. Guess what? It works great!
But I am not sure if I did the right thing: my computer uses bash, I could not find either .bash_profile. There is only one file named "profile" under the "/etc/" directory. So I just put the "/usr/local/mysql/bin" into the directory, and it works! Thank you a bunch! Regards, Hon -----Original Message----- On Friday, Sep 5, 2003, at 10:24 US/Eastern, Parker Morse wrote: > You'll need to edit the .bashrc file in your home directory to add the > /usr/local/mysql/bin directory to the search path if you want to avoid > typing the full path. Another alternative is to place links to the > binaries in one of the directories already in the path, like > /usr/bin/. I should correct myself - the file to look at is .bash_profile, not .bashrc, at least in RH 9.0. Or .tcsh_profile (or .tcshrc) if you use tcsh - I don't, so I'm not certain which file it would be in. And, as Mike suggests, check to make sure the MySQL client is there at /usr/local/mysql/bin/mysql. It might be that simple. pjm -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, September 05, 2003 10:30 AM To: Parker Morse Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Command not found Also make sure you installed both the server and the client for MySQL. And of course if you're not running bash, put the path to the MySQL directory in the correct shell file. For example, I prefer the tsch shell, so I would put it in the .tcshrc file in my home directory. If you're not familiar with Linux, take a look at some of the commands at http://www.reallylinux.com/docs/consult.shtml. If you want a book, http://www.amazon.com/exec/obidos/ASIN/0972679006/qid%3D1041438546/sr%3D11-1 /ref%3Dsr%5F11%5F1/103-4038995-5196662 will get you a quick start. Parker Morse <[EMAIL PROTECTED] To: [EMAIL PROTECTED] m> cc: [EMAIL PROTECTED] Subject: Re: Command not found 09/05/2003 09:24 AM On Friday, Sep 5, 2003, at 00:51 US/Eastern, [EMAIL PROTECTED] wrote: > I installed the MySQL 4.0 on my Linxus machine (red hat 7.3). The > installation > shows no problem, and I can see that the 'mysqld' server is actually > runing > through a command like "./bin/mysqladmin version". However, it just > does not > allow me to switch to the mysql client program from my login shell. > Whenever I > try to do so, it also says that "bash: mysql: command not found". > > I don't know how to deal with it. Could some MySQL experts please > kindly help > me with this? It's not a MySQL issue, it's a Linux issue. If your MySQL binaries are installed in a directory like /usr/local/mysql/bin/, they're not in one of the directories your shell (probably bash) looks in for commands. (To see which directories are being searched, type "echo $PATH" at the shell prompt.) You'll need to edit the .bashrc file in your home directory to add the /usr/local/mysql/bin directory to the search path if you want to avoid typing the full path. Another alternative is to place links to the binaries in one of the directories already in the path, like /usr/bin/. pjm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
