SET SQL_SAFE_UPDATES = 0; use mysql; update user set host = '%' where user = 'root'; FLUSH PRIVILEGES;