select host,user,grant_priv,super_priv from mysql.user; update mysql.user set host='%' where user='root'; flush privileges;