View Single Post
  #5 (permalink)  
Old February 19th, 2006, 10:13 AM
lanc71 lanc71 is offline
Registered User
 
Join Date: Feb 2006
Location: Bologna, , Italy.
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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!
Reply With Quote