Thank you for your input. Ok I now have a user with privileges but it still crashes instantly.
I could be wrong but I'm inclined to think this problem is more fundamental to the application than MySQL. Any additional thoughts would be ideal - a step-by-step idiot proof guide to installing MySQL onto a Windows 7 PC and setting everything up to work with Gnucash would be even better :-) Regards -----Original Message----- From: jh [mailto:[email protected]] Sent: 26 November 2010 08:37 To: Ian X Waddington Cc: gnucash-devel; gnucash-user Subject: Save As MySQL is crashing gnucash Hi, I think you should file this as a bug! No matter what mistake you make as a user, Gnucash should not crash, but rather give you a reasonable error message and handle the situation gracefully (what Gnucash usually does). On my Ubuntu machine, after installing MySQL, I had to log into the MySQL-client on the commandline with: mysql -u root -p Then at the mysql prompt enter: CREATE USER 'gncuser'@'localhost' IDENTIFIED BY 'gncpw'; GRANT ALL PRIVILEGES ON *.* TO 'gncuser'@'localhost'; Now I could use MySQL from within Gnucash. Juergen On Fri, 2010-11-26 at 07:18 +0000, Ian X Waddington wrote: > Thank you, the entries in the archives suggest that a save as in > gnucash changing the type to mysql would create a database of name > gnucash with the user id and password I had entered. > > Is this now not the case? > > -----Original Message----- > From: Robert Heller [mailto:[email protected]] > Sent: 26 November 2010 00:02 > To: Ian X Waddington > Cc: [email protected]; Robert Heller > Subject: Re: Save As MySQL is crashing gnucash > > At Thu, 25 Nov 2010 22:59:47 -0000 "Ian X Waddington" > <[email protected]> > wrote: > > > > > Hi > > > > > > > > On a Windows 7 machine I am running gnucash 2.3.17 and have just > > installed MySql 5.1.53 > > > > > > > > When I select file-save-as (with a new blank file of an existing > > test > > file) I get the MySQL form to fill in and choose localhost, gnucash, > > (made up userid), (made up password) - gnucash immediately crashes > > and windows 7 tells me I've had an APPCRASH in > > libgncmod-backend-dbi.dll > > made up userid, made up password ? > > You can't just 'make up' a username and password. You need to login > to mysql as the root user and create a username with a password. You > probably also need to create a database (named gnucash I presume). > Under Linux/UNIX one would fire up the mysql command from a shell with > the root user and password. I believe a *fresh* install leaves the > root user with no password (which really should get changed as the > first post install step). Creating users and databases is covered in > the MySQL reference manual. > > > > > > > > > I've search the list archives but could not find anything that > > seemed relevant so I would be grateful for any help or suggestions > > > > > > > > Regards > > > > _______________________________________________ > > gnucash-user mailing list > > [email protected] > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > ----- > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > > > > _______________________________________________ gnucash-devel mailing list [email protected] https://lists.gnucash.org/mailman/listinfo/gnucash-devel
