mysql> use mysql;
Database changed
mysql> update user set host = '%' where user = 'root';
Query OK, 0 rows affected
Rows matched: 1 Changed: 0 Warnings: 0
mysql> grant all privileges on *.* to 'root'@'%'with grant option;
Query OK, 0 rows affected
mysql> flush privileges;
Query OK, 0 rows affected
mysql>