Grant previlage problem -mysql
i have create user in myql
then assign privileges to the user for particular db,that user should have all privileges create,select,insert etc...
CREATE USER 'testuser'@'localhost' IDENTIFIED BY 'testpass'"
so i have use the query like this
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.
GRANT ALL PRIVILEGES ON dbname.* TO testuser'@% IDENTIFIED BY 'testpass'")