[Koha] koha install fails with database error

[Marilen Corciovei]

mysqladmin -u root -pyour_mysql_root_pass create koha
mysql -u root -pyour_mysql_root_pass
mysql> grant all on koha.* to 'kohaadmin'@'localhost' identified by
'your_kohaadmin_pass';
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> quit

Len
www.len.ro


On Sun, 2008-06-08 at 11:50 -0500, Aren Olson wrote:

> I created the database with the default config for Ubuntu, and set a
> root user password. I did no additional configuration on this
> database, and am inexperienced with mysql in general. The last time I
> installed koha (a year or so ago, on Ubuntu 6.06), the database was
> set up correctly for me without my needing to do any more, so I was
> expecting the same here.
> 
> Could you please tell me the exact commands needed to set up mysql by
> hand, if that is feasible? The rest of koha appears to be installed
> fine.  I am almost completely inexperienced with mysql so I will need
> detailed instructions.
> 
> Thanks,
> Aren
> 
> On Sun, Jun 8, 2008 at 01:37, Marilen Corciovei
> <marilen.corciovei at nemesisit.ro> wrote:
> > This is a mysql permissions problem. Check:
> >
> > - that you created the database
> > - created the user with grant all
> > - flushed the priviledges
> > - can connect using mysql -u kohadmin -pyour_password koha
> >
> > Len
> > www.len.ro
> >
> > On Thu, 2008-06-05 at 18:21 -0700, Aren Olson wrote:
> >
> > I'm installing the latest koha 2 on Ubuntu 8.04, and installation
> > fails with the following error:
> >
> >  CREATING DATABASE
> >
> > 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...
> >
> > any ideas?
> >
> > Please CC me as I'm not subscribed to the list.
> >
> > Thanks,
> > Aren Olson
> >
> >
> 
> 
> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20080608/2af1ad47/attachment.htm