#1044 - Access denied for user 'root'@'localhost' to database 'wordpress"

[Florian Longueteau]

Hi all,

i've got a big problem while trying to give some grants to a user on a database.
Here is it :
- i'm trying to install wordpress on my own server (which unbuntu dapper running on it, and mysql 'Ver 14.12 Distrib 5.0.22, for pc-linux-gnu (i486) using readline 5.1')
- so I create a new user 'wordpress', a new database 'wordpress', and when I'm trying to give all the rights to the user 'wordpress' on the data 'base' wordpress, here is what mysql say (via the web interafce phpmyadmin) :

"Error

SQL query:

GRANT ALL PRIVILEGES ON `wordpress` . * TO 'wordpress'@'localhost' WITH GRANT OPTION ;

MySQL said: Documentation
#1044 - Access denied for user 'root'@'localhost' to database 'wordpress' "

I've been searching for solutions for 2 days now, and nothing solved the problem.

Can someone help me ?
Thanks.