Hi, I'm having a problem of starting mySQL.. well I'm actually forgot what did I do a long time ago that mess the mySQL up in my server. Well now when I'm trying to execute this command from the terminal such as: /etc/init.d/mysql start .. instead of starting the terminal give me an error said Can't execute /usr/local/mysql/bin/mysqld_safe from dir /usr/local/mysql.

Well I have no clue how to fix it. Is anyone can help me with this problem? Please help ...

By the way i'm running mysql on redhat 9.0 and mysql version is 3.23.54

do a which safe_mysqld and report it back here

you shouldn't be starting things manually from /etc/init.d and safe_mysqld shouldn't be living there.

how about forcing mysql-server back onto your system to clear up any missing files ,etc?
rpm -Uvh mysql-server --force

Try this:

/usr/local/bin/safe_mysqld --user=mysql &

change the path to the correct path to your safe_mysqld if it's not the same