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@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