[bryanthompson]

I've got a linux Q...

I have a box running RH9, and when I start it up and ps -A, I can see tons of mysql processes running. I have a java program that uses a mysql database, but it won't pick up those mysql processes... either they're some other type, or they're running on the wrong port, or there's a bigger problem. Anyway, if I /usr/local/mysql/bin/mysqld_safe & from root then run my java prog, it all works fine.

Anyway... I added my mysqld_safe command to my /etc/rc.local and rebooted, but didn't see it in my process list, and my java prog didn't see it either. I tried running the startup command from the terminal, and it yelled at me saying that it was already in use.

What I need to do, is have it so when the computer's turned on it will start the mysql server, then run my java program. I'd like to have the java program run as user "weather" and the mysqld started as root.