Get the MySQL path

Question

I tried googling to get the MySql path, but it was unsuccessful. Is there a unix command, where I can find the MySQL database directory path?

Answer 1

Try this query,

SHOW VARIABLES LIKE 'datadir';

Answer 2

Find the my.cnf and then find the datadir

sudo find / -name "my.cnf" | xargs cat | grep "datadir" | cut -d" " -f2

or if you know the location of the configuration file

cat /etc/mysql/my.cnf | grep "datadir" | cut -d" " -f2