mysql> GRANT ALL ON *.* TO 'root'@'%';
Query OK, 0 rows affected
mysql> flush privileges;
Query OK, 0 rows affected
mysql>
GRANT ALL PRIVILEGES ON *.* TO 'mysqlroot'@'%' with grant option;
Query OK, 0 rows affected
mysql> GRANT ALL ON *.* TO 'root'@'%';
Query OK, 0 rows affected
mysql> flush privileges;
Query OK, 0 rows affected
mysql>
GRANT ALL PRIVILEGES ON *.* TO 'mysqlroot'@'%' with grant option;
Query OK, 0 rows affected