Using MySQL with GnuCash

[Hossain]

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


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