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

Art pinaart at
Fri Aug 24 23:12:53 EDT 2012

I don't recall the exact steps I took, so I'm repeating it.
I clicked on the GnuCash menu entry which points to,
  F:\usr\gnucash\bin\gnucash.exe (v2.4.11 built from svn r22268 on 2012-07-15)

and get,
  GnuCash could not obtain the lock for mysql://root@
So, I clicked the "Open Anyway" button as I have done before and

it goes back to the splash screen, acting like it's going to open the database, but Windows 7 just displays the blue "busy" circle until the pop-up,
gnucash.exe has stopped working
comes up and I do "Close program".

I invoke it again, but this time, I say "Cancel" and open my 18 MB GnuCash_XML file from 2009.

Now, I do "Save as..." to mysql on localhost with Database "gc120825", Username "root" and it fails with,
  The server at URL mysql://root@localhost/gc120825 experienced an error or encountered bad or corrupt data.
(The MySQL commandline interface shows,
F:\usr\MySQL\MySQL Server 5.5\bin\mysql.exe  Ver 14.14 Distrib 5.5.24, for Win64 (x86)

So I hit the "Close" button and do it again, but this time I set Host to and get the same error.

I give up on that one open 2009_converted_120816.gnucash.
I can't save that one either so I do a File -> Quit from GnuCash.
I created an empty file, Test1.gnucash. It has the default 5 accounts with zero balances on each.
I did a save as mysql://root@localhost/test1a, successfully.
I did File -> close.
I reinvoked GnuCash from the Start menu and got a pop-up, "Error",
  Unspecified fatal error encountered, aborting.

I did Ok to close it. I then got another pop-up, "Microsoft Visual C++ Runtime Library",
  This application has requested the Runtime to terminate it in an unusual way.
Please contact the application's support team for more information.

Ok - this one could be my fault! I recently discovered some Windows Updates were not being applied, so I did some gross clean-ups two days ago! This involved zapping all Microsoft Visual Studio applications and C++ (2005 - 2010, including runtime and Redistribute packages).
Since I wasn't getting this specific error before - I apologize for wasting your time - I will reimage my system and start from a pristine state before I test GnuCash again.
(Doh! I just hate going back 6 months... to my previous known good system.)

Thank you,


 From: Derek Atkins <derek at>
To: vArt <pinaart at> 
Cc: Colin Law <clanlaw at>; "gnucash-devel at" <gnucash-devel at> 
Sent: Friday, August 24, 2012 2:18 PM
Subject: Re: Is there a step-by-step, "How to setup a MySQL database for use with GnuCash"?

On Fri, August 24, 2012 4:08 pm, Art wrote:
> Correct. It hangs when I try to open the same db it saved.
> Any subsequent re-starts of GnuCash do the same for that database.

How did you exit GnuCash after your File -> Save As?
What happens if you click "open anyways"?

> - Art


> ________________________________
>  From: Colin Law <clanlaw at>
> To: Art <pinaart at>
> Cc: "gnucash-devel at" <gnucash-devel at>
> Sent: Friday, August 24, 2012 12:57 PM
> Subject: Re: Is there a step-by-step, "How to setup a MySQL database for
> use with GnuCash"?
> 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?
> Colin
> [deleted my text below for brevity - Art]
> _______________________________________________
> gnucash-devel mailing list
> gnucash-devel at

       Derek Atkins                 617-623-3745
      derek at   
       Computer and Internet Security Consultant

More information about the gnucash-devel mailing list