0

How to give full privileges to the user in MySQL

mysql

I have created the new database and the user in that respective DB...

Now i need to grant the privileges to that user for full access instead of localhost. what is the syntax....??

ethan
asked Jan 11, 2017
2 Answer
0

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;

View More
jagan
answered Jan 10, 2017
0

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 ......?

View More
akr
answered Feb 8, 2017
Your Answer
||||
x
 
100:0