Where is my MySQL database on the server?

Where is my MySQL database on the server?

Usually /var/lib/MySQL or /var/db/mysql directory used to store database and tales under UNIX like operating systems.

You can use the following command to locate MySQL data-dir:

On windows:

 

>mysqladmin variables | findstr "datadir" 

on Linux : 

>mysqladmin variables | grep datadir 

OR

>grep datadir /etc/my.cnf