My SQL on OSX problem

I am at my wits end...

[dada78]

I was following the MySQl install guide closely and got to the point where to find out which shell I am using, which is "/bin/tcsh"

BUT NOW I am stuck:
the guide instructs:

--> If you are using the tcsh shell you will have to modify the file ".tcshrc" located within your home directory.

1st problem: I couldn't find this file and since it has a "." it is also hidden by the system.

2nd problem: create a new file in your text editor and add the following line at the bottom of your file:

setenv PATH "$PATH":/Library/MySQL/bin

save the file

I don't know how to create this file, where to save it and how to edit it if I can't find it?

Help, or I am loosing my mind :0

Thanks guys
Dada

[redtwister]

Open Terminal (in the Utilities folder of your Applications folder) and type

pico .tcshrc (then return)

It may or may not have existed before. Add the line

setenv PATH "$PATH":/Library/MySQL/bin

then Ctrl-O (and return) to write the file and Ctrl-X to exit.

That's it. Oh....and to find hidden files in Terminal just type

ls -a

[lZakl]

dada78,

You may have heard this before (or read it...) Terminal is going to be one of your best friends when administering MySQL. You may want to get a "reference book" or at least a cheet-sheet with an explaination of how terminal works, and how to use it effectively. When you are "well versed" in Termainl, you will find it a pretty powerful tool in doing more than just administering MySQL, but you WILL be able to administer MySQL more effectivly at that point ;0)

-- Zak

[dada78]

Thanks so much for your help guys! I will try it out right away and also buy a book!

Dada