HORDE [emergency] [imp] DB Error: insufficient permissions

[allie at daneman.net]

I tried it to no avail. Same error everytime:
Dec 13 15:39:27 HORDE [emergency] [imp] DB Error: insufficient permissions: 
[nativecode=Access denied for user: '@localhost' to database 'horde'] **

I'm using the mysql_create.sql script and changed the params per below with no
difference. I'm using horde-2.1 and imp-3.1. I'm just learning mysql so that
could be part of the problem. Any help would be greatly appreciated....doing my
preferences by session sucks.

$conf['prefs']['driver'] = 'session';

// Any parameters that the preferences driver needs. This includes
// database or ldap server, username/password to connect with, etc.
$conf['prefs']['params'] = array();

// This is an example configuration for a MySQL preference backend.
// The SQL script to setup the preference database is placed in
// horde/scripts/db/prefs.sql.
$conf['prefs']['params']['phptype'] = 'mysql';
$conf['prefs']['params']['hostspec'] = 'localhost';
$conf['prefs']['params']['username'] = 'hordemgr';
$conf['prefs']['params']['password'] = 'secret_password';
$conf['prefs']['params']['database'] = 'horde';
$conf['prefs']['params']['table'] = 'horde_prefs';


Quoting Charly Root <root@papendorf-se.de>:

> I think this is probably because the default horde prefs use 'hordemgr' as 
> username but the mysql_create.sql uses 'horde', the mysql_create.sql should 
> look something like this:
> 
> REPLACE INTO user (host, user, password)
>     VALUES (
>         'localhost',
>         'hordemgr',
>   -- IMPORTANT: Change this password!
>         password('secret')
>     );
> 
> 
> REPLACE INTO db (host, db, user, select_priv, insert_priv, update_priv,
>                  delete_priv, create_priv, drop_priv)
>     VALUES (
>         'localhost',
>         'horde',
>         'hordemgr',
>         'Y', 'Y', 'Y', 'Y',
>         'Y', 'Y'
>     );
> 
> FLUSH PRIVILEGES;
> 




-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/