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;
Thats fine.... at last you have given @'localhost' right, it will work only in that host... I cant use it in remote MySQL... how to change the syntax???
ohh for remote access just use wildcard symbol instead of 'localhost'
CREATE USER 'testing'@'%' IDENTIFIED BY 'password'; GRANT ALL ON * . * TO 'testing'@'%';
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 ......?