mysql> grant all privileges on *.* to ‘root’@’%’ ;
Query OK, 0 rows affected (0.08 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.07 sec)