how to check mysql location

[usafshah]

Hi


I have installed mysql from source file (tar.gz) which had some problem so i have to install again from rpm from CD.

Now mysql is running i dont know which one is running... how can i check the information about running mysql and its location ?

[Motoma]

Hi


I have installed mysql from source file (tar.gz) which had some problem so i have to install again from rpm from CD.

Now mysql is running i dont know which one is running... how can i check the information about running mysql and its location ?

The mysqladmin tool should be able to provide you with this information.

[vpmurdan]

typing

\s

in the mysql prompt gives you the location

[usafshah]

typing

\s

in the mysql prompt gives you the location

[root@linuxserve r ~]# \s
-bash: s: command not found

[usafshah]

The mysqladmin tool should be able to provide you with this information.

where in phpmyadmin i didn't find... and also how can i delete that mysql which i had installed from source tar.gz

[Motoma]

where in phpmyadmin i didn't find... and also how can i delete that mysql which i had installed from source tar.gz

mysqladmin is a command line tool to get information and change settings of your mysql server.

[vpmurdan]

Hi.

In PHPMyAdmin, on the screen where you type sql commands type:

show variables like 'base%';

the base dir will give you the location of your mysql installation.

For re-installing (i am talking under reserve as I'm not so fluent on linux)

something like 'rpm -q' to check the fileName of mysql
something like 'rpm -u FileName' to uninstall

Prakash

[bugmenot]

I would recommend ps -ef | grep mysql and checking the output. Good chance you will see it there.