2 Answer
Just give asterisk (*) symbol instead of the respective Db name... For example: I created the user called 'testing' and am going to give the full privileges as follows,
GRANT ALL PRIVILEGES ON * . * TO 'testing'@'localhost'; FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON * . * TO 'testing'@'localhost'; FLUSH PRIVILEGES; in above tag have you given full privileges for that user it is similar to act as root access fine. now my question is how to give particular database and particular table access to user ......?
Your Answer
x