Grant privilege for MySQL

GRANT ALL PRIVILEGES ON *.* TO ‘root’@’%’ IDENTIFIED BY ‘root’ WITH GRANT OPTION;
GRANT ALL ON *.* to root@’%’ IDENTIFIED BY ‘root’;

meaning :
1. create user with ‘GRANT OPTION’ grant
2. grant all privilege to all objects to user

Advertisements