MySQL - OSX

Hi there ladies/gents!

I am trying to install MYSQL on OSX. and is plagued with the following error:

The Objective: To be able to just type "mysql" to access the "mysql" command. instead of typing the full path: shell> /Library/MySQL/bin/mysql

After trying to install MySQL I made an attempt to add the directory "/Library/MySQL/bin" to $PATH environment variable in the shell.
(I am actually using a ".tcshrc" shell).

The manual said:
You will have to modify the file ".tcshrc" located within your home directory.

I could not locate that file

The next step was to create a new one.

"I really dont know how to do this"
Could anyone provide me with some step by step tips in order to achieve this?

Help is greatly appreciated...

Try running shell> /Library/MySQL/bin/mysql

If the client works, the only problem you have is you can't type:

shell> mysql

Which is shorter.

go to http://www.entropy.ch Marc Liyanage has DETAILED instructions for install on OS X and you can copy and paste his commands into the terminal if you don't really know what you're doing. he has a line that will allow you to do what you're talking about...in fact it is:

echo 'export PATH=/usr/local/mysql/bin:$PATH' >> ~/.bash_profile

for Panther...and for Jaguar it is:

echo 'setenv PATH /usr/local/mysql/bin:$PATH' >> ~/.tcshrc