Hi

i have create user in myql

Code:
CREATE USER 'testuser'@'localhost' IDENTIFIED BY 'testpass'"
then assign privileges to the user for particular db,that user should have all privileges create,select,insert etc...

so i have use the query like this

Code:
  GRANT ALL PRIVILEGES ON  dbname.* TO testuser'@% IDENTIFIED BY 'testpass'")
it show the privileges option as usage only in mysql, how can i give all privileges ,can any one tell me what wrong in my query, i couldnt create table with the user.