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...Code: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.Code:GRANT ALL PRIVILEGES ON dbname.* TO testuser'@% IDENTIFIED BY 'testpass'")