i have create user in myql
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
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.