Is there a step-by-step, "How to setup a MySQL database for use with GnuCash"?

Colin Law clanlaw at
Fri Aug 24 15:57:55 EDT 2012

On 24 August 2012 20:53, Art <pinaart at> wrote:
> Hi!
> I don't know if I should ask this in a different forum, but I've experimented with GnuCash for several years, but recently wanted to just use the MySQL database for my finances and GnuCash can never read them. It can create a database which I can read from the MySQL commandline interface, but GnuCash simply hangs when I try doing it from it.

Do you mean that if you do Save As and select the mysql option that it
creates the db ok, but then if you close and re-open gnucash that it
does not re-open the mysql db?


> I've looked at the log files and seem to recall there is some record it doesn't like. It does complain that it cannot obtain a lock. I am just learning MySQL and have no problem using it with LAMP or Windows AMP web server apps which I've customized to track my bills and I'd like to reconcile my bills against my financial accounts.
> I've tried the latest GnuCash built for Windows under Windows 7 and am using the latest 64-bit MySQL from Oracle. I assumed there would be no problem due to 32-bit vs. 64-bit apps since the transactions were using well-defined format data objects at the API level. (I wanted to build GnuCash from source for debugging purposes, but gave up. I just don't have time with my lifestyle interfering.) I was hoping it was something easy to fix that someone who's done this with a similar environment can explain.
> Thank you,
> Art
> _______________________________________________
> gnucash-devel mailing list
> gnucash-devel at

More information about the gnucash-devel mailing list