[LBo] Serendipity and MySQL

[Jisao]

I am trying to install Serendipity, and I run into a few glitches.  The 
first one is that I know almost nothing about MySQL.

1.  I have tested Apache, PHP5 and MySQL and they work.

2.  According to the Serendipity FAQ, there are some pre-requisites to 
installing Serendipity:


    Serendipity requires that you have already setup the Database in
    your favorite database system. For MySQL you can create a database
    with "CREATE DATABASE serendipity;" for example, on postgreSQL you
    can do that via "createdb serendipity". The username you enter in
    the Serendipity Installations also requires that this username
    already exists. On MySQL you create users via the "GRANT" feature
    subset. Use a tool like phpMyAdmin to easily create users, or just
    enter the credentials you were given from your hoster. On postgreSQL
    you can create a user with "createuser serendipity" for example.

    The reason why Serendipity does not create a database automatically
    is because on most hosting providers you already have an existing
    database (like usrdb_htdu1_sql) and are not able to create more
    databases. To make serendipity detect that and guess the right user
    privileges would be too error-prone. So it is best that you create
    an empty database with the right privileges to use for Serendipity
    (assign CREATE, INSERT, UPDATE, DELETE, ALTER and INDEX privileges
    for the SQL user account).


So I did create the empty database serendipity, and I have created a 
user kubian with the CREATE, INSERT, UPDATE, DELETE, ALTER and INDEX  on 
*.* (whatever that is).

However, when I tried to configured dbconfig-common to set up the 
serendipity database, I get the following error message:

 >granting access to database serendipity for kubian at localhost: -e failed.
 >error encountered creating user:
 >mysql said: ERROR 1044 (42000) at line 1: Access denied for user 
'kubian at localhost' to database 'serendipity'
 >dbconfig-common: serendipity configure: aborted.
 >dbconfig-common: flushing administrative password.

What should I do next (other than installing Wordpress)?

Thank you.

Jisao