Need procedure to setup mysql for Gnucash in window

[Colin Law]

2009/12/4 durgaprasad alaparthi <8765439 at gmail.com>:
> Hi,
>
> I have only one root user in Mysql. I have tried creating database in mysql
> directly from Mysql client. But I am not able to create the database from
> GNUCash.
>

Did you create a database in Mysql using localhost and username
narayana and password narayana?  (on the same pc as you are running
GC)

If so try creating a db called gnucash and then try GnuCash again.

Does anyone know if there is a way to get more information when GC
fails to connect or write to the database?

Colin

> Regards,
> Lakshminarayana
>
> On Fri, Dec 4, 2009 at 9:37 PM, durgaprasad alaparthi <8765439 at gmail.com>
> wrote:
>>
>> Hi Colin,
>>
>> I am using GNUCash 2.3.7. I have not created any database in Mysql. Can
>> you please let me know whether it is required to create a database?
>>
>> Regards,
>> Lakshminarayana
>>
>> On Fri, Dec 4, 2009 at 9:32 PM, Derek Atkins <warlord at mit.edu> wrote:
>>>
>>> Hi,
>>>
>>> durgaprasad alaparthi <8765439 at gmail.com> writes:
>>>
>>> > Hi Colin,
>>> >
>>> > Thanks for explaining the procedure. I have followed the steps
>>> > mentioned in
>>> > the mail. However GNUCash is giving following error.
>>> >
>>> > "The server at URL mysql://localhost:gnucash:narayana:narayana
>>> > experienced
>>> > an error or encountered bad or corrupt data."
>>> >
>>> > Can you please let me know how this error can be resolved?
>>> >
>>> > Note: 1. I have installed Mysql5.1 Newly and did not create any
>>> > database or
>>> > tables related to GNUCash. I have just created new Account Hirerachy in
>>> > GNUCash and selected Mysql as the database to save the data.
>>>
>>> I believe you need to have created the database (but not any tables).
>>> Hopefully Phil will correct me if I am wrong.  Do you have your mysql
>>> user set up correctly?  Also, what version of GnuCash are you using?
>>>
>>> > Regards,
>>> > Lakshminarayana
>>>
>>> > Please remember to CC this list on all your replies.
>>> > You can do this by using Reply-To-List or Reply-All.
>>>
>>> -derek
>>> --
>>>       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>>>       Member, MIT Student Information Processing Board  (SIPB)
>>>       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
>>>       warlord at MIT.EDU                        PGP key available
>>
>
>