Problems with connecting to MySQL database

[Michael Kremser]

Hi!

I am yet inexperienced with MySQL, but have some years of experience with MS SQL and Oracle DBMS.

I have a machine running Xubuntu 8.04.1 with MySQL 5. I wanted to set up Wordpress, which requires a MySQL database. I created one like this:

mysql> create database wordpress;
Query OK, 1 row affected (0.00 sec)

Then I wanted to create the required user for Wordpress:

mysql> create user 'wp' identified by 'wp';
Query OK, 0 rows affected (0.03 sec)

But connecting to the database always fails:

michael@xubvtm1:~$ mysql -u wp -p wordpress
Enter password:
ERROR 1045 (28000): Access denied for user 'wp'@'localhost' (using password: YES)

I tried these SQL statements to grant access:

mysql> grant all on wordpress.* to 'wp';
Query OK, 0 rows affected (0.02 sec)

mysql> grant all on wordpress.* to 'wp'@'localhost';
Query OK, 0 rows affected (0.03 sec)

mysql> grant all on wordpress.* to wp@localhost;
Query OK, 0 rows affected (0.03 sec)

mysql> grant all privileges on wordpress.* to wp@localhost;
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.03 sec)

But none of them worked so far. :-(

I guess it's just a small mistake I've done.

Can anyone help me?

Best regards,

Michael