Need to know the location of database file in ubuntu 14

Hi All,

I need to know the location of database file and how to access it remotely ?

Thanks in advance ,

Ragav

If you’re trying to access the ERPNext database, you can use the command bench mysql

Refer to this for where the files are stored : https://mariadb.com/kb/en/mariadb/default-data-directory-for-mariadb/

Accessing it remotely would need you to open the port for MariaDB

Thank you so much for your swift response sir , it has been mentioned in the link that the files will be stored under /var/lib/mysql but unfortunately i could not find anything in that folder and nothing is mentioned in the config file ?

@ragav

We use the default directory, i.e /var/lib/mysql

In the my.cfg file, you can find the location, under the “Basic Settings” section as :

datadir = /var/lib/mysql

Thank you sir , i got it .