MySQL/MariaDB connection

Contents Up Previous Next

MySQL/MariaDB connection

MySQL/MariaDB An important feature of yatish is its ability to connect to a MySQL/MariaDB server. One can use this optional functionality to:

backup data;
synchronise devices if working on several ones;
provide willingfull access to your data (a reader version of yatish will be provided in the future).

But then you must of course provide credentials: yatish expects to find a yatish.auth file alongside yatish.sqlite in your personal data directory.

You had better check that you alone have read/write access to this file:

Linux: chmod 600;
Windows: Right Click>Properties>Security.

The yatish.auth must follow this template

[MySQL]
server=xxx   #domain name or IP address
database=yyy #yatish database
user=zzz     #MySQL/MariaDB user
password=***

This template is also provided system-wide for you to copy:

Linux: /usr/local/share/yatish/yatish.auth;
Windows: C:\Windows\Program files\Yatish\sql\yatish.auth.