Did you work this out? I've had what seems to be the same problem. I've created users from the command line and logged in as them, but when I try from the createmovie.php file I get the error message "Access denied for user 'bp5am'@'localhost' to database 'moviesite'" despite having set the privileges as in the book on page 24. I've cured that now, but got a php error.
What I did was redo the user by including CREATE in the GRANT statement. I think this is new as of php 5, so if that's what you're running it might be worth a try.
|