Gnucash + mysql

[John Ralls]

> On Dec 18, 2017, at 6:29 AM, Wolfgang Paul Rauchholz <wp.rauchholz at gmail.com> wrote:
> 
> Didn't think about that possibility.
> Let me try this out too.
> 
> Do you know whether there are plans to extend usage of mysql in gnucash?
> 


Not MySQL per se, but we do intend to make GnuCash a proper database application eventually. It’s a major change in the design and there’s a ton of preparation work that must happen first so it will take several years to accomplish.

In the meantime, there’s no cookbook, but if you already know how to manage a MySQL installation it shouldn’t be too difficult. Create a user with CREATE DATABASE privilege in MySQL.
Open GnuCash, create a new book, and when the save dialog comes up select “MySQL” from the list-box at the top. You’ll get a new dialog prompting for the server’s address, a name for the database (which defaults to “gnucash” but you probably want something more descriptive, and a userid and password. Fill those in, click save, and GnuCash takes care of the rest.

Do *not* try to pre-create a database. GnuCash needs to do that itself.

Regards,
John Ralls