November
19
MySQL: update a remote user connection
mysql -u root -p
SELECT User, Host FROM mysql.user;
UPDATE mysql.user SET host = ‘newservername.domainname.com or ip’ where host = ‘originalservername.domainname.com or ip’ AND user = ‘root’;
flush privileges;
