Codice PHP:
GRANT SELECT , 
INSERT , 

UPDATE , 
DELETE , 
FILE ON * . * TO '$user'@ 'localhost' IDENTIFIED BY '$pass' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0" ; 
questi sono i privilegi dell' utente.. in pratica dice ke l utente può inserire file, può modificarli e cancellarli..

però la query non funziona lo stesso..

mi riporta :

CREATE USER 'prova1'@ 'localhost' IDENTIFIED BY 'prova'; GRANT SELECT , INSERT , UPDATE , DELETE , FILE ON * . * TO 'prova1'@ 'localhost' IDENTIFIED BY 'prova' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''localhost' IDENTIFIED BY 'prova'; GRANT SELECT , INSERT , UPDATE , ' at line 1