<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.18.2">
</HEAD>
<BODY>
mysqladmin -u root -pyour_mysql_root_pass create koha<BR>
mysql -u root -pyour_mysql_root_pass<BR>
mysql> grant all on koha.* to 'kohaadmin'@'localhost' identified by 'your_kohaadmin_pass';<BR>
Query OK, 0 rows affected (0.00 sec)<BR>
<BR>
mysql> flush privileges;<BR>
Query OK, 0 rows affected (0.00 sec)<BR>
<BR>
mysql> quit<BR>
<BR>
Len<BR>
<A HREF="http://www.len.ro">www.len.ro</A><BR>
<BR>
<BR>
On Sun, 2008-06-08 at 11:50 -0500, Aren Olson wrote:
<BLOCKQUOTE TYPE=CITE>
<PRE>
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
<<A HREF="mailto:marilen.corciovei@nemesisit.ro">marilen.corciovei@nemesisit.ro</A>> 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
> <A HREF="http://www.len.ro">www.len.ro</A>
>
> 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
>
>
</PRE>
</BLOCKQUOTE>
</BODY>
</HTML>