Figuring out absolute path of mysql to execute shell script.

Question

How to figure out the mysql location on a server (windows or linux)?

I would like to run

mysql -u USER -p PASS DATABASE < filename.sql

but I need the absolute path to mysql, how do I find out?

Answer 1

Unix/Linux: which mysql returns the path to the mysql executable

I don't know about windows.

Answer 2

which mysql wont return anything if its not already in the path.

on linux you can use

updatedb locate mysql

or `find / -name "mysql" -print

Windows just use their crappy search tool

Answer 3

echo $_SERVER["MYSQL_HOME"];