Crazy MySQL Problem

[Dr. Shim]

I've installed MySQL occording to the instructions located in the INSTALL-BINARY file. I used the mysql-4.0.12.tar.gz package, since the RPM version doesn't seem to work properly when I use "rpm -i" on it.
Anyhow, I've carefully followed the instructions, extracted it to the /usr/local/mysql directory, ect. My problem is that whenever I try to execute any of the files in the /usr/local/mysql/bin/ directory, I get a bash error telling me that the command was not found.
This is very strange. I've set the permissions properly, according to the instructions. Here's what I did (these commands where executed whilst I was in the /usr/local/ directory):

# chown -R root .
# chown -R mysql data
# chgrp -R mysql .

I tried executing the files as a normal user too, but to no avail. Could anybody assist me? What's goin' on here? :confused:

P.S. I did not add a link to the /usr/local/ directory to the mysql directory, since in the "detailed" version of the instructions located in the INSTALL-BINARY file made no mention of doing this.

[mdwatts]

You will find that 'echo $PATH' does not include /usr/local/mysql/bin which means you will either need to add '/usr/local/mysql/bin' to your path or prefix the commands with './' (./command) to tell the shell to look in the current working directory for the command.

[Dr. Shim]

How would I go about adding it to my $PATH?

# $PATH=$PATH+":/usr/local/mysql/bin"

:confused:

[bigrigdriver]

Edit /etc/ld.so.conf and add the path there. Then run ldconfig to pick up the added path (man ldconfig for more infor).

[Dr. Shim]

I've tried adding /usr/local/mysql/bin to the mentioned file. I ran ldconfig and $PATH still doesn't include the directory. Here's now the file looks like:

/usr/X11R6/lib:/usr/local/mysql/bin

I also tried adding it like this:

/usr/X11R6/lib
/usr/local/mysql/bin

But $PATH still doesn't show it.

Update: And I found out that if I use the former (contactinated using a colon) KDE, KWM, and other services won't start. Yech.