Using MySQL with GnuCash

[Colin Law]

On 14 September 2015 at 20:27, Hossain <contacthossain at gmail.com> wrote:
> I tried but failed. I use WAMP server for MySQL. Do I have to install (WAMP)
> it in both PC to
> connect to a remote Mysql server? In my MySQL main server PC , I made a user
> for GNUCash
> and grant it all privileges from ANYHOST. After I installed GNUCash in
> remote PC, I tried to
> connect to remote MySQL server by using the IP address of the MySQL server's
> PC AS HOST
> and "gnucash" as Datbase name, username that I created above and password.
> But It shows an error

You don't need WAMP, just the mysql server on the server machine, you
don't need anything special on the client machine except possibly
something like the mysql command line client (see below).

Before trying to get gnucash going check using the mysql command line
(or similar) on the client that you can connect to mysql on the
server.  Until you get that going this is not a gnucash issue but a
mysql issue.

Colin

>
>
> On 14-Sep-2015 9:14 PM, Colin Law wrote:
>>
>> On 14 September 2015 at 15:56, Hossain <contacthossain at gmail.com> wrote:
>>>
>>> Hello, I want to save the GNUCash data to MySQL server , Hence, I
>>> installed
>>> WAMP.
>>> GnuCash can connect to MySQL server very well but I dont see any related
>>> database tables or data
>>> in the database I made for Gnucash with PhpAdmin. Do I have to set the
>>> saving preference at the beginningm when I make the file?
>>> I did it later.
>>
>> You don't need to make the database in advance, GnuCash will make it
>> if necessary when you save it.  Just select mysql as the type to save
>> as and provide the database name, user and password and it should do
>> it.  You should then be able to see the data in phpadmin.
>>
>> Does GC appear to save the data as mysql ok?
>> Does mysql://.... then appear in the GC title bar?
>> Can you close GC and and re-open it and the data are still there?
>> If so then it is saving the data ok so if you can't see it in
>> phpmyadmin then the problem lies there not in gc.  You may have to
>> refresh phpmyadmin after saving in GC.
>>
>> Colin
>
>