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

[Marty]

Thanks, but does not work...

I did:
mysql> GRANT ALL ON Koha.* TO 'kohaadmin'@'localhost' IDENTIFIED BY 'mypassword';
Query OK, 0 rows affected (0.06 sec)

But I am actually granting privileges on a database that does not yet exist? Anyway, it does not work, I still get:

CREATING DATABASE

Creating the MySQL database for Koha...

ERROR 1045 (28000): Access denied for user 'kohaadmin'@'localhost' (using passwo                   rd: 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 also found that when entering a password for the database I get this message;
Password for database user kohaadmin: password
Use of uninitialized value in concatenation (.) or string at Install.pm line 1358, <STDIN> line 10.

Does that matter anyhow?

Thanks, 
Marty




--- On Mon, 2/2/09, savitra sirohi <savitra.sirohi at osslabs.biz> wrote:

> From: savitra sirohi <savitra.sirohi at osslabs.biz>
> Subject: Re: [Koha] Access denied for user 'kohaadmin'@'localhost' koha 2.2.9  setup
> To: ontariowolf64 at yahoo.com
> Cc: "Joe Atzberger" <ohiocore at gmail.com>, "koha koha" <koha at lists.katipo.co.nz>
> Date: Monday, February 2, 2009, 11:34 PM
> 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
> >