GRANT problem with MySql 5.1.48

[Elizabeth Boulton]

I have followed instructions carefully in several tutorials and still am not successful granting permissions to a user in MySql.


mysql> GRANT ALL on resourceProject.* TO 'resourceUser'@'localhost' IDENTIFIED BY 'resourceUserPassword';
Query OK, 0 rows affected (0.02 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT host, user, password, Select_priv FROM mysql.user;
+-----------+----------------+----------------------------------------------------------------+-------------+
| host | user | password | Select_priv |
+-----------+----------------+----------------------------------------------------------------+-------------+
| localhost | root | root Password | Y |
| localhost | resourceUser | *04087AC6924F981A8A38B40241452B1358A39E3D | N |
+-----------+----------------+----------------------------------------------------------------+-------------+
2 rows in set (0.00 sec)

mysql> select user();
+----------------+
| user() |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.00 sec)

I can login as this user; but I can't execute even a simple SELECT.

What am I missing? Thank you for taking the time to respond.