Get MySQL path as a $var

robembra

Hi,

I would like to get the path of mysql as a $var.
e.g. $var = \usr\local\bin\mysql.

I have tried running through system() exec() passthru() and shell_exec():

"which mysql" & "whereis mysql" but I dont get the correct output. I either get output "1" or "/usr/local/man/man1/mysql.1.gz" and not the path to mysql.

It doesnt have to be a command that gets the path but was the only way i could think of getting such information.

Thanks for any help!

halojoy

You can pull this information out of your MySQL database.
Because there is one standard database in MySQL that holds such.

The database name is information_schema.
Has got one table called GLOBAL_VARIABLES.

Of course, if you are on a hosted website, you can not do this.
You will not have access to the information_schema database.

Here is a script to get the path to MySQL basedirectory:

<?php

$db = mysql_connect('localhost','xxxxxx','xxxxxx');
if (!$db) {
    die('Not connected : ' . mysql_error());
}
$db_selected = mysql_select_db('information_schema', $db);
if (!$db_selected) {
    die('Not selected : ' . mysql_error());
}

$var = 'BASEDIR';

$result = mysql_query("SELECT VARIABLE_VALUE FROM GLOBAL_VARIABLES WHERE VARIABLE_NAME='$var'");
$row = mysql_fetch_array($result);
if (!$row) {
    die('No result : ' . mysql_error());
}

echo $var.': '.$row['VARIABLE_VALUE'];

?>

NogDog

If the web server user running PHP (e.g. typically "nobody" on Apache servers) does not have it in its path environment variable, then a which is not going to find it. (In fact, it's probably preferable that it not be in that user's path.)

Any particular reason you need to know this, instead of using the built in MySQL extension?

robembra

Thanks forn the reply,

But my information_schema has NOT got one table called GLOBAL_VARIABLES. 😕

robembra

I would like the path because I wrote a script a while back and I have shared it with a few people and now some mysql features and mysqldump of my script doesnt work anymore, and I need the full path to mysql.