[Koha] Access denied for user 'kohaadmin'@'localhost' koha 2.2.9 setup

[savitra sirohi]

Marty,

Granting permissions to this user on the koha database might work.

Rgds,
Savitra
Nucsoft OSS Labs
www.osslabs.biz

On Tue, Feb 3, 2009 at 8:45 AM, Marty <ontariowolf64 at yahoo.com> wrote:
> Thanks Joe,
> but I do not have a KOHA_CONF file, I do have a koha.conf file, maybe because I have a Linux installation (Debian), its' contents are:
> database=koha
> hostname=localhost
> user=Koha
> pass='mypassword'
>
> the password is the password that allows me to log in from root using mysql -u kohaadmin -p, so I am still stuck...
>
> Marty
>
>
>
> --- On Mon, 2/2/09, Joe Atzberger <ohiocore at gmail.com> wrote:
>
>> From: Joe Atzberger <ohiocore at gmail.com>
>> Subject: Re: [Koha] Access denied for user 'kohaadmin'@'localhost' koha 2.2.9  setup
>> To: ontariowolf64 at yahoo.com
>> Cc: "koha koha" <koha at lists.katipo.co.nz>
>> Date: Monday, February 2, 2009, 8:25 PM
>> The password goes in your KOHA_CONF file.  For 2.2 that
>> should be a flat
>> text file.
>> --joe
>>
>> On Mon, Feb 2, 2009 at 8:07 PM, Marty
>> <ontariowolf64 at yahoo.com> wrote:
>>
>> > I am making my own life miserable.... While installing
>> koha 3 I
>> > accidentally somehow deleted koha 2.2.9 (Yes, yes,
>> stupid, I know, luckily
>> > it's not the production server yet)
>> > So, I thought, big deal, I reinstall it (for the sake
>> of updating from
>> > there to koha 3) but I keep getting this:
>> >
>> > Creating the MySQL database for Koha...
>> >
>> > ERROR 1045 (28000): Access denied for user
>> 'kohaadmin'@'localhost' (using
>> > password: YES)
>> >
>> > DBI
>> connect('Koha:localhost','kohaadmin',...)
>> failed: Access denied for
>> > user 'kohaadmin'@'localhost' (using
>> password: YES) at
>> > /usr/local/koha/intranet/modules/C4/Context.pm line
>> 411
>> > Can't call method "prepare" on an
>> undefined value at
>> > scripts/updater/updatedatabase line 1553.
>> > Problem updating database...
>> >
>> > I do have the password, I can login to mysql
>> > debian:/home/marty/koha-2.2.9# mysql -u kohaadmin -p
>> > Enter password:
>> > Welcome to the MySQL monitor.  Commands end with ; or
>> \g.
>> >
>> > So where do I enter the password? Or what could be
>> wrong?
>> > I had Koha 2.2.9 running fine until I screwed up....
>> >
>> > Marty
>> >
>> >
>> >
>> >
>> > _______________________________________________
>> > Koha mailing list
>> > Koha at lists.katipo.co.nz
>> > http://lists.katipo.co.nz/mailman/listinfo/koha
>> >
>
>
>
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>