When you create the user and password, you also have to 'add' them to access the database.
When you do add them, you have the chance to set the permissions or ACL. There is also the "ALL PRIVILEGES" check box.
I happen to use a PHP-based CMS and the install script didn't work until I modified...