Page 24 (for my Italian translation):
Quote:
quote:
mysql> GRANT SELECT, INSERT, UPDATE
-> ON *.*
-> TO edna@localhost
-> IDENTIFIED BY 'ednapass';
|
As you can see edna can't create database, just
Quote:
quote:
SELECT, INSERT, UPDATE
|
So for files createmovie.php and moviedata.php of pages 94-96 you must not use
Quote:
quote:
mysql> GRANT SELECT, INSERT, UPDATE
-> ON *.*
-> TO bp5am@localhost
-> IDENTIFIED BY 'bp5ampass';
|
but
Quote:
quote:
mysql> GRANT CREATE, SELECT, INSERT, UPDATE
-> ON *.*
-> TO bp5am@localhost
-> IDENTIFIED BY 'bp5ampass';
|
or better, as TheDudeTux said
Code:
GRANT ALL PRIVILEGES
for
Code:
GRANT CREATE, SELECT, INSERT, UPDATE
Hey TheDudeTux, as you can see the question of Debbie is of october 2005, maybe she has just understood from herself the question!