location of MySQL Directory in Red Hat
 

Hi,

where is the location of MySQL Directory in Red Hat?

i have done this:

[me@cctv me]$ whereis mysql
mysql: /usr/bin/mysql /usr/lib/mysql /usr/share/mysql /usr/share/man/man1/mysql.
1.gz
[me@cctv me]$


i think it is /usr/bin/mysql.

and is there a way i can access the MySQL data outside MySQL, e.g. can i copy the database file and open it in Acess lets say???


thanks,

It depends...
 

on what you mean by "MySQL directory", and possibly on the RH version.

To see the location of the file that executes when you invoke MySQL do a "which MySQL" from a shell prompt. That gets me a response of /usr/bin/mysql on both my RH 7.3 server and on my RH 8.0 workstation.

Try "more /etc/my.cnf" to see where key files are for MySQL. Databases are under /var/lib/mysql for both my RH boxes, as that is defined in the my.cnf file as the "datadir".

I believe that you can export the data, but don't recall specifics. You might consider using ODBC to access MySQL databases with Access. I believe that there is a "MyODBC" that allows this. Probably you can find info on it at www.mysql.com.

diffrent file located under diffrent directory its not like windows all file are uder same directory to find it
locate mysql

if give error first do updatedb

You must want to see where is Mysqld, that's the server for mysql, do a locate mysqld and start mysqld, first read the manual from mysql to know the parameters well