update user set host = '%' where user = 'root'; grant all privileges on *.* to root@'%' identified by "password";